Catalogue de requêtes génériques

Block Dashboard (Elément de tableau de bord)

Liste des groupes

SELECT

g.id AS gid,
c.shortname as cs,
cc1.name as cc1,
cc2.name as cc2,
c.fullname as cn,
g.name as g,
g.timecreated AS gc,
g.timemodified AS gm,
COUNT(*) as gms

FROM

{course} c,
{course_categories} cc1,
{course_categories} cc2,
{groups} g,
{groups_members} gm

WHERE

cc1.id = c.category AND
cc2.id = cc1.parent AND
c.id = g.courseid AND
g.id = gm.groupid

GROUP BY

g.id

ORDER BY

cc2.name,cc1.name,c.fullname,g.name

Configuration

Tzo4OiJzdGRDbGFzcyI6MTA1OntzOjU6InRpdGxlIjtzOjE3OiJMaXN0ZSBkZXMgZ3JvdXBlcyI7czoxMzoiaW5ibG9ja2xheW91dCI7czoxOiIwIjtzOjY6InRhcmdldCI7czo2OiJtb29kbGUiO3M6ODoic2hvd2RhdGEiO3M6MToiMSI7czo5OiJzaG93Z3JhcGgiO3M6MToiMSI7czoxMToic2hvd251bXN1bXMiO3M6MToiMSI7czo5OiJzaG93cXVlcnkiO3M6MToiMCI7czoxNzoic2hvd2ZpbHRlcnF1ZXJpZXMiO3M6MToiMCI7czo1OiJxdWVyeSI7czo0OTI6IlNFTEVDVA0KICBnLmlkIEFTIGdpZCwNCiAgYy5zaG9ydG5hbWUgYXMgY3MsDQogIGNjMS5uYW1lIGFzIGNjMSwNCiAgY2MyLm5hbWUgYXMgY2MyLA0KICBjLmZ1bGxuYW1lIGFzIGNuLA0KICBnLm5hbWUgYXMgZywNCiAgZy50aW1lY3JlYXRlZCBBUyBnYywNCiAgZy50aW1lbW9kaWZpZWQgQVMgZ20sDQogIENPVU5UKCopIGFzIGdtcw0KRlJPTQ0KICB7Y291cnNlfSBjLA0KICB7Y291cnNlX2NhdGVnb3JpZXN9IGNjMSwNCiAge2NvdXJzZV9jYXRlZ29yaWVzfSBjYzIsDQogIHtncm91cHN9IGcsDQogIHtncm91cHNfbWVtYmVyc30gZ20NCldIRVJFDQogICAgY2MxLmlkID0gYy5jYXRlZ29yeSBBTkQNCiAgICBjYzIuaWQgPSBjYzEucGFyZW50IEFORA0KICAgIGMuaWQgPSBnLmNvdXJzZWlkIEFORA0KICAgIGcuaWQgPSBnbS5ncm91cGlkDQpHUk9VUCBCWQ0KICAgIGcuaWQNCk9SREVSIEJZDQogICAgY2MyLm5hbWUsY2MxLm5hbWUsYy5mdWxsbmFtZSxnLm5hbWUNCiI7czoxNToicXVlcnlyb3RhdGVjb2xzIjtzOjA6IiI7czoxNjoicXVlcnlyb3RhdGVwaXZvdCI7czowOiIiO3M6MTg6InF1ZXJ5cm90YXRlbmV3a2V5cyI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyMSI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWwxIjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlMSI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzMSI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyMiI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWwyIjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlMiI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzMiI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyMyI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWwzIjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlMyI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzMyI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyNCI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWw0IjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlNCI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzNCI7czowOiIiO3M6OToidGFibGV0eXBlIjtzOjY6ImxpbmVhciI7czoxMjoib3V0cHV0ZmllbGRzIjtzOjI1OiJjYzI7Y2MxO2NzO2NuO2c7Z2M7Z207Z21zIjtzOjExOiJmaWVsZGxhYmVscyI7czo2OToiQ2F0w6lnb3JpZTtTb3VzLWNhdMOpZ29yaWU7Q29kZTtDb3VycztHcm91cGU7Q3LDqcOpO01vZGlmacOpO0VmZmVjdGlmIjtzOjEzOiJvdXRwdXRmb3JtYXRzIjtzOjIzOiIlczslczslczslczslczslRDslRDslZCI7czo4OiJwYWdlc2l6ZSI7czowOiIiO3M6MTU6InVzZWxvY2FsY2FjaGluZyI7czoxOiIxIjtzOjEwOiJjYWNoaW5ndHRsIjtzOjA6IiI7czoxMjoiY2xlYW5kaXNwbGF5IjtzOjE6IjEiO3M6MjI6ImNsZWFuZGlzcGxheXVwdG9jb2x1bW4iO3M6MDoiIjtzOjg6InNvcnRhYmxlIjtzOjE6IjEiO3M6MTU6InNwbGl0c3Vtc29uc29ydCI7czowOiIiO3M6MTI6InZlcnRpY2Fsa2V5cyI7czowOiIiO3M6ODoiaG9yaXprZXkiO3M6MDoiIjtzOjE1OiJ2ZXJ0aWNhbGZvcm1hdHMiO3M6MDoiIjtzOjExOiJob3JpemZvcm1hdCI7czowOiIiO3M6Nzoic3BsaXRvbiI7czowOiIiO3M6OToiaG9yaXpzdW1zIjtzOjE6IjAiO3M6ODoidmVydHN1bXMiO3M6MToiMCI7czoxNDoidmVydGljYWxsYWJlbHMiO3M6MDoiIjtzOjEwOiJob3JpemxhYmVsIjtzOjA6IiI7czoxMToicGFyZW50c2VyaWUiO3M6MDoiIjtzOjEwOiJ0cmVlb3V0cHV0IjtzOjA6IiI7czoxNzoidHJlZW91dHB1dGZvcm1hdHMiO3M6MDoiIjtzOjc6ImZpbHRlcnMiO3M6MDoiIjtzOjEyOiJmaWx0ZXJsYWJlbHMiO3M6MDoiIjtzOjE0OiJmaWx0ZXJkZWZhdWx0cyI7czowOiIiO3M6MTM6ImZpbHRlcm9wdGlvbnMiO3M6MDoiIjtzOjc6Im51bXN1bXMiO3M6MDoiIjtzOjEzOiJudW1zdW1mb3JtYXRzIjtzOjA6IiI7czoxMjoibnVtc3VtbGFiZWxzIjtzOjA6IiI7czo5OiJncmFwaHR5cGUiO3M6NDoibGluZSI7czoxMDoieGF4aXNmaWVsZCI7czowOiIiO3M6MTA6InhheGlzbGFiZWwiO3M6MDoiIjtzOjc6InlzZXJpZXMiO3M6MDoiIjtzOjE0OiJ5c2VyaWVzZm9ybWF0cyI7czowOiIiO3M6MTI6InNlcmllc2xhYmVscyI7czowOiIiO3M6NDoieW1pbiI7czowOiIiO3M6NDoieW1heCI7czowOiIiO3M6MTE6InRpY2tzcGFjaW5nIjtzOjA6IiI7czoxMDoieWF4aXNsYWJlbCI7czowOiIiO3M6MTA6ImdyYXBod2lkdGgiO3M6MzoiNDUwIjtzOjExOiJncmFwaGhlaWdodCI7czozOiIyNTAiO3M6MTA6InNob3dsZWdlbmQiO3M6MToiMCI7czo3OiJtYXB0eXBlIjtzOjc6IlJPQURNQVAiO3M6NDoiem9vbSI7czoxOiI2IjtzOjEwOiJkYXRhdGl0bGVzIjtzOjA6IiI7czoxMzoiZGF0YWxvY2F0aW9ucyI7czowOiIiO3M6OToiZGF0YXR5cGVzIjtzOjA6IiI7czozOiJsYXQiO3M6MToiMCI7czozOiJsbmciO3M6MToiMCI7czoxMzoic2hvd2xvd2VyYmFuZCI7czoxOiIxIjtzOjEzOiJ1cHBlcmJhbmR1bml0IjtzOjU6Ik1PTlRIIjtzOjEzOiJsb3dlcmJhbmR1bml0IjtzOjQ6IllFQVIiO3M6MTg6InRpbWVsaW5lZXZlbnR0aXRsZSI7czowOiIiO3M6MTg6InRpbWVsaW5lZXZlbnRzdGFydCI7czowOiIiO3M6MTY6InRpbWVsaW5lZXZlbnRlbmQiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWV2ZW50bGluayI7czowOiIiO3M6MTc6InRpbWVsaW5lZXZlbnRkZXNjIjtzOjA6IiI7czoxNDoidGltZWxpbmVjb2xvcnMiO3M6MDoiIjtzOjE4OiJ0aW1lbGluZWNvbG9yZmllbGQiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWNvbG9ya2V5cyI7czowOiIiO3M6ODoiY3Jvbm1vZGUiO3M6OToibm9yZWZyZXNoIjtzOjg6ImNyb25ob3VyIjtzOjA6IiI7czo3OiJjcm9ubWluIjtzOjA6IiI7czoxMzoiY3JvbmZyZXF1ZW5jeSI7czo1OiJkYWlseSI7czo4OiJtYWtlZmlsZSI7czoxOiIxIjtzOjEwOiJmaWxlb3V0cHV0IjtzOjA6IiI7czoxNzoiZmlsZW91dHB1dGZvcm1hdHMiO3M6MDoiIjtzOjEwOiJmaWxlZm9ybWF0IjtzOjM6IkNTViI7czoxNToiZmlsZXNxbG91dHRhYmxlIjtzOjA6IiI7czoxMjoiZmlsZWxvY2F0aW9uIjtzOjA6IiI7czoyMToiZmlsZXBhdGhhZG1pbm92ZXJyaWRlIjtzOjA6IiI7czo4OiJzYXZldmlldyI7czoyMzoiRW5yZWdpc3RyZXIgZXQgYWZmaWNoZXIiO3M6OToic3FscGFyYW1zIjtOO3M6OToiaXNydW5uaW5nIjtpOjA7czo4OiJsYXN0Y3JvbiI7aTowO3M6MTM6ImV4cG9ydGNoYXJzZXQiO3M6NDoidXRmOCI7fQ==

Crédits

Valéry Frémaux (valery@activeprolearn.com)- Développements et documentation

Florence Labord (florence@activeprolearn.com) - documentation

Revenir au catalogue de requêtes génériques - Index du composant - Revenir à l'index des plugins - Revenir au catalogue