Table des matières
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
