blocks:dashboard:querycatalogue:querycourseyear

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

blocks/dashboard/querycatalogue/querycourseyear.txt · Dernière modification : de 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki