Table des matières
Catalogue de requêtes génériques
Block Dashboard (Elément de tableau de bord)
Histogramme annuel des connexions par cours et par mois
Rendu avec filtres par cours et par an, et données de sortie par mois, utilisateurs disctincts et visites du cours
SELECT
CONCAT(FROM_UNIXTIME(l.timecreated, '%Y-%m'), '-', c.id) as pkey, FROM_UNIXTIME(l.timecreated, '%Y-%m') as month, FROM_UNIXTIME(l.timecreated, '%Y') as year, c.fullname as cn, COUNT(DISTINCT l.userid) as dusr, COUNT(*) as usr
FROM
{course} c,
{course_categories} cc1,
{course_categories} cc2,
{logstore_standard_log} l
WHERE
c.category = cc1.id AND cc1.parent = cc2.id AND l.courseid = c.id AND l.action = 'viewed' <%%FILTERS%%>
GROUP BY
FROM_UNIXTIME(l.timecreated, '%Y-%m')
Configuration
Tzo4OiJzdGRDbGFzcyI6MTAzOntzOjU6InRpdGxlIjtzOjM2OiJGcsOpcXVlbnRhdGlvbiB0ZW1wb3JlbGxlIGRlcyBjb3VycyAiO3M6MTM6ImluYmxvY2tsYXlvdXQiO3M6MToiMCI7czo2OiJ0YXJnZXQiO3M6NjoibW9vZGxlIjtzOjg6InNob3dkYXRhIjtzOjE6IjEiO3M6OToic2hvd2dyYXBoIjtzOjE6IjEiO3M6MTE6InNob3dudW1zdW1zIjtzOjE6IjEiO3M6OToic2hvd3F1ZXJ5IjtzOjE6IjAiO3M6MTc6InNob3dmaWx0ZXJxdWVyaWVzIjtzOjE6IjAiO3M6NToicXVlcnkiO3M6NTM5OiJTRUxFQ1QNCiAgIENPTkNBVChGUk9NX1VOSVhUSU1FKGwudGltZWNyZWF0ZWQsICclWS0lbScpLCAnLScsIGMuaWQpIGFzIHBrZXksDQogICBGUk9NX1VOSVhUSU1FKGwudGltZWNyZWF0ZWQsICclWS0lbScpIGFzIG1vbnRoLA0KICAgRlJPTV9VTklYVElNRShsLnRpbWVjcmVhdGVkLCAnJVknKSBhcyB5ZWFyLA0KICAgYy5mdWxsbmFtZSBhcyBjbiwNCiAgIENPVU5UKERJU1RJTkNUIGwudXNlcmlkKSBhcyBkdXNyLA0KICAgQ09VTlQoKikgYXMgdXNyDQpGUk9NDQogIHtjb3Vyc2V9IGMsDQogIHtjb3Vyc2VfY2F0ZWdvcmllc30gY2MxLA0KICB7Y291cnNlX2NhdGVnb3JpZXN9IGNjMiwNCiAge2xvZ3N0b3JlX3N0YW5kYXJkX2xvZ30gbA0KV0hFUkUNCiAgYy5jYXRlZ29yeSA9IGNjMS5pZCBBTkQNCiAgY2MxLnBhcmVudCA9IGNjMi5pZCBBTkQNCiAgbC5jb3Vyc2VpZCA9IGMuaWQgQU5EDQogIGwuYWN0aW9uID0gJ3ZpZXdlZCcNCiAgPCUlRklMVEVSUyUlPg0KR1JPVVAgQlkNCiAgRlJPTV9VTklYVElNRShsLnRpbWVjcmVhdGVkLCAnJVktJW0nKSI7czoxMjoic3FscGFyYW12YXIxIjtzOjA6IiI7czoxNDoic3FscGFyYW1sYWJlbDEiO3M6MDoiIjtzOjEzOiJzcWxwYXJhbXR5cGUxIjtzOjY6ImNob2ljZSI7czoxNToic3FscGFyYW12YWx1ZXMxIjtzOjA6IiI7czoxMjoic3FscGFyYW12YXIyIjtzOjA6IiI7czoxNDoic3FscGFyYW1sYWJlbDIiO3M6MDoiIjtzOjEzOiJzcWxwYXJhbXR5cGUyIjtzOjY6ImNob2ljZSI7czoxNToic3FscGFyYW12YWx1ZXMyIjtzOjA6IiI7czoxMjoic3FscGFyYW12YXIzIjtzOjA6IiI7czoxNDoic3FscGFyYW1sYWJlbDMiO3M6MDoiIjtzOjEzOiJzcWxwYXJhbXR5cGUzIjtzOjY6ImNob2ljZSI7czoxNToic3FscGFyYW12YWx1ZXMzIjtzOjA6IiI7czoxMjoic3FscGFyYW12YXI0IjtzOjA6IiI7czoxNDoic3FscGFyYW1sYWJlbDQiO3M6MDoiIjtzOjEzOiJzcWxwYXJhbXR5cGU0IjtzOjY6ImNob2ljZSI7czoxNToic3FscGFyYW12YWx1ZXM0IjtzOjA6IiI7czoxMjoib3V0cHV0ZmllbGRzIjtzOjE0OiJtb250aDtkdXNyO3VzciI7czoxMzoib3V0cHV0Zm9ybWF0cyI7czo4OiIlczslZDslZCI7czo4OiJwYWdlc2l6ZSI7czowOiIiO3M6MTU6InVzZWxvY2FsY2FjaGluZyI7czoxOiIwIjtzOjEwOiJjYWNoaW5ndHRsIjtzOjA6IiI7czoxMjoiY2xlYW5kaXNwbGF5IjtzOjE6IjEiO3M6MjI6ImNsZWFuZGlzcGxheXVwdG9jb2x1bW4iO3M6MDoiIjtzOjg6InNvcnRhYmxlIjtzOjE6IjEiO3M6MTU6InNwbGl0c3Vtc29uc29ydCI7czowOiIiO3M6MTE6ImZpZWxkbGFiZWxzIjtzOjQ2OiJNb2lzO1V0aWxpc2F0ZXVycyBkaXN0aW5jdHM7VmlzaXRlcyAoZHUgY291cnMpIjtzOjk6InRhYmxldHlwZSI7czo2OiJsaW5lYXIiO3M6NzoiZmlsdGVycyI7czo1OToiYy5mdWxsbmFtZSBhcyBjbjtGUk9NX1VOSVhUSU1FKGwudGltZWNyZWF0ZWQsICclWScpIGFzIHllYXIiO3M6MTI6ImZpbHRlcmxhYmVscyI7czoxMzoiQ291cnNlO0FubsOpZSI7czoxNDoiZmlsdGVyZGVmYXVsdHMiO3M6MTA6IkZJUlNUO0xBU1QiO3M6MTM6ImZpbHRlcm9wdGlvbnMiO3M6NToic3g7bXgiO3M6MTI6InZlcnRpY2Fsa2V5cyI7czowOiIiO3M6ODoiaG9yaXprZXkiO3M6MDoiIjtzOjE1OiJ2ZXJ0aWNhbGZvcm1hdHMiO3M6MDoiIjtzOjExOiJob3JpemZvcm1hdCI7czowOiIiO3M6Nzoic3BsaXRvbiI7czowOiIiO3M6OToiaG9yaXpzdW1zIjtzOjE6IjAiO3M6ODoidmVydHN1bXMiO3M6MToiMCI7czoxNDoidmVydGljYWxsYWJlbHMiO3M6MDoiIjtzOjEwOiJob3JpemxhYmVsIjtzOjA6IiI7czoxMToicGFyZW50c2VyaWUiO3M6MDoiIjtzOjEwOiJ0cmVlb3V0cHV0IjtzOjA6IiI7czoxNzoidHJlZW91dHB1dGZvcm1hdHMiO3M6MDoiIjtzOjEwOiJ4YXhpc2ZpZWxkIjtzOjU6Im1vbnRoIjtzOjEwOiJ4YXhpc2xhYmVsIjtzOjQ6Ik1vaXMiO3M6NzoieXNlcmllcyI7czo4OiJkdXNyO3VzciI7czoxNDoieXNlcmllc2Zvcm1hdHMiO3M6MjoiJWQiO3M6NDoieW1pbiI7czoxOiIwIjtzOjQ6InltYXgiO3M6MzoiNjAwIjtzOjExOiJ0aWNrc3BhY2luZyI7czoxOiI1IjtzOjEwOiJ5YXhpc3NjYWxlIjtzOjY6ImxpbmVhciI7czoxMjoic2VyaWVzbGFiZWxzIjtzOjMwOiJVdGlsaXNhdGV1cnMgZGlzdGluY3RzO1Zpc2l0ZXMiO3M6MTA6InlheGlzbGFiZWwiO3M6MTI6IlV0aWxpc2F0ZXVycyI7czoxNDoieWF4aXN0aWNrYW5nbGUiO3M6MzoiLTQ1IjtzOjk6ImdyYXBodHlwZSI7czozOiJiYXIiO3M6MTA6ImdyYXBod2lkdGgiO3M6MzoiOTUwIjtzOjExOiJncmFwaGhlaWdodCI7czozOiI0NTAiO3M6MTA6InNob3dsZWdlbmQiO3M6MToiMCI7czo3OiJtYXB0eXBlIjtzOjc6IlJPQURNQVAiO3M6NDoiem9vbSI7czoxOiI2IjtzOjEwOiJkYXRhdGl0bGVzIjtzOjA6IiI7czoxMzoiZGF0YWxvY2F0aW9ucyI7czowOiIiO3M6OToiZGF0YXR5cGVzIjtzOjA6IiI7czozOiJsYXQiO3M6MToiMCI7czozOiJsbmciO3M6MToiMCI7czoxMzoic2hvd2xvd2VyYmFuZCI7czoxOiIxIjtzOjEzOiJ1cHBlcmJhbmR1bml0IjtzOjU6Ik1PTlRIIjtzOjEzOiJsb3dlcmJhbmR1bml0IjtzOjQ6IllFQVIiO3M6MTg6InRpbWVsaW5lZXZlbnR0aXRsZSI7czowOiIiO3M6MTg6InRpbWVsaW5lZXZlbnRzdGFydCI7czowOiIiO3M6MTY6InRpbWVsaW5lZXZlbnRlbmQiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWV2ZW50bGluayI7czowOiIiO3M6MTc6InRpbWVsaW5lZXZlbnRkZXNjIjtzOjA6IiI7czoxNDoidGltZWxpbmVjb2xvcnMiO3M6MDoiIjtzOjE4OiJ0aW1lbGluZWNvbG9yZmllbGQiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWNvbG9ya2V5cyI7czowOiIiO3M6NzoibnVtc3VtcyI7czowOiIiO3M6MTM6Im51bXN1bWZvcm1hdHMiO3M6MDoiIjtzOjEyOiJudW1zdW1sYWJlbHMiO3M6MDoiIjtzOjg6ImNyb25tb2RlIjtzOjk6Im5vcmVmcmVzaCI7czo4OiJjcm9uaG91ciI7czowOiIiO3M6NzoiY3Jvbm1pbiI7czowOiIiO3M6MTM6ImNyb25mcmVxdWVuY3kiO3M6NToiZGFpbHkiO3M6ODoibWFrZWZpbGUiO3M6MToiMCI7czoxMDoiZmlsZW91dHB1dCI7czowOiIiO3M6MTc6ImZpbGVvdXRwdXRmb3JtYXRzIjtzOjA6IiI7czoxMDoiZmlsZWZvcm1hdCI7czozOiJDU1YiO3M6MTU6ImZpbGVzcWxvdXR0YWJsZSI7czowOiIiO3M6MTI6ImZpbGVsb2NhdGlvbiI7czowOiIiO3M6MjE6ImZpbGVwYXRoYWRtaW5vdmVycmlkZSI7czowOiIiO3M6ODoic2F2ZXZpZXciO3M6MjM6IkVucmVnaXN0cmVyIGV0IGFmZmljaGVyIjtzOjk6InNxbHBhcmFtcyI7TjtzOjk6ImlzcnVubmluZyI7aTowO3M6ODoibGFzdGNyb24iO2k6MDt9
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