Table des matières
Catalogue de requêtes génériques
Block Dashboard (Elément de tableau de bord)
Liste des ressources consultées par utilisateurs
- Actuellement sur 5 types de ressources : url, tests, devoirs, page, dossier
- Filtrage par cours
- Filtrage par usager
SELECT
CONCAT(cm.id, '-', u.id) as pkey,
CONCAT(u.lastname, ' ', u.firstname) as user,
cm.id,
c.shortname as sn,
c.fullname as fn,
cc1.name as cc1,
m.name as rtype,
CASE WHEN m.name = 'resource' THEN r.name
WHEN m.name = 'page' THEN p.name
WHEN m.name = 'url' THEN ur.name
WHEN m.name = 'quiz' THEN q.name
WHEN m.name = 'workshop' THEN w.name
WHEN m.name = 'folder' THEN f.name ELSE 'N.C.' END as rname,
COUNT(*) as viewes,
MAX(l.timecreated) as lastview
FROM
{modules} m,
{user} u,
{course} c,
{course_categories} cc1,
{logstore_standard_log} l,
{course_modules} cm
LEFT JOIN
{resource} r
ON
r.id = cm.instance
LEFT JOIN
{url} ur
ON
ur.id = cm.instance
LEFT JOIN
{folder} f
ON
f.id = cm.instance
LEFT JOIN
{quiz} q
ON
q.id = cm.instance
LEFT JOIN
{page} p
ON
p.id = cm.instance
LEFT JOIN
{workshop} w
ON
w.id = cm.instance
WHERE
m.id = cm.module AND
m.name IN('resource', 'page', 'url', 'folder', 'quiz') AND
cm.course = c.id AND
cc1.id = c.category AND
l.objecttable = m.name AND
l.objectid = cm.instance AND
l.userid = u.id AND
l.action = 'viewed'
<%%FILTERS%%>
GROUP BY
CONCAT(cm.id, '-', u.id)
Configuration
Tzo4OiJzdGRDbGFzcyI6MTA0OntzOjU6InRpdGxlIjtzOjQ4OiJMaXN0ZSBkZXMgcmVzc291cmNlcyBjb25zdWx0w6llcyBwYXIgdXRpbGlzYXRldXIiO3M6MTM6ImluYmxvY2tsYXlvdXQiO3M6MToiMCI7czo2OiJ0YXJnZXQiO3M6NjoibW9vZGxlIjtzOjg6InNob3dkYXRhIjtzOjE6IjEiO3M6OToic2hvd2dyYXBoIjtzOjE6IjEiO3M6MTE6InNob3dudW1zdW1zIjtzOjE6IjEiO3M6OToic2hvd3F1ZXJ5IjtzOjE6IjAiO3M6MTc6InNob3dmaWx0ZXJxdWVyaWVzIjtzOjE6IjAiO3M6NToicXVlcnkiO3M6MTM0NjoiU0VMRUNUDQogICBDT05DQVQoY20uaWQsICctJywgdS5pZCkgYXMgcGtleSwNCiAgIENPTkNBVCh1Lmxhc3RuYW1lLCAnICcsIHUuZmlyc3RuYW1lKSBhcyB1c2VyLA0KICAgY20uaWQsDQogICBjLnNob3J0bmFtZSBhcyBzbiwNCiAgIGMuZnVsbG5hbWUgYXMgZm4sDQogICBjYzEubmFtZSBhcyBjYzEsDQogICBtLm5hbWUgYXMgcnR5cGUsDQogICBDQVNFIFdIRU4gbS5uYW1lID0gJ3Jlc291cmNlJyBUSEVOIHIubmFtZQ0KICAgICAgICAgICAgICBXSEVOIG0ubmFtZSA9ICdwYWdlJyBUSEVOIHAubmFtZQ0KICAgICAgICAgICAgICBXSEVOIG0ubmFtZSA9ICd1cmwnIFRIRU4gdXIubmFtZQ0KICAgICAgICAgICAgICBXSEVOIG0ubmFtZSA9ICdxdWl6JyBUSEVOIHEubmFtZQ0KICAgICAgICAgICAgICBXSEVOIG0ubmFtZSA9ICd3b3Jrc2hvcCcgVEhFTiB3Lm5hbWUNCiAgICAgICAgICAgICAgV0hFTiBtLm5hbWUgPSAnZm9sZGVyJyBUSEVOIGYubmFtZSBFTFNFICdOLkMuJyBFTkQgYXMgcm5hbWUsDQogICBDT1VOVCgqKSBhcyB2aWV3ZXMsDQogICBNQVgobC50aW1lY3JlYXRlZCkgYXMgbGFzdHZpZXcNCkZST00NCiAgIHttb2R1bGVzfSBtLA0KICAge3VzZXJ9IHUsDQogICB7Y291cnNlfSBjLA0KICAge2NvdXJzZV9jYXRlZ29yaWVzfSBjYzEsDQogICB7bG9nc3RvcmVfc3RhbmRhcmRfbG9nfSBsLA0KICAge2NvdXJzZV9tb2R1bGVzfSBjbQ0KTEVGVCBKT0lODQogICB7cmVzb3VyY2V9IHINCk9ODQogICByLmlkID0gY20uaW5zdGFuY2UNCkxFRlQgSk9JTg0KICAge3VybH0gdXINCk9ODQogICB1ci5pZCA9IGNtLmluc3RhbmNlDQpMRUZUIEpPSU4NCiAgIHtmb2xkZXJ9IGYNCk9ODQogICBmLmlkID0gY20uaW5zdGFuY2UNCkxFRlQgSk9JTg0KICAge3F1aXp9IHENCk9ODQogICBxLmlkID0gY20uaW5zdGFuY2UNCkxFRlQgSk9JTg0KICAge3BhZ2V9IHANCk9ODQogICBwLmlkID0gY20uaW5zdGFuY2UNCkxFRlQgSk9JTg0KICAge3dvcmtzaG9wfSB3DQpPTg0KICAgdy5pZCA9IGNtLmluc3RhbmNlDQpXSEVSRQ0KICAgbS5pZCA9IGNtLm1vZHVsZSBBTkQNCiAgIG0ubmFtZSBJTigncmVzb3VyY2UnLCAncGFnZScsICd1cmwnLCAnZm9sZGVyJywgJ3F1aXonKSBBTkQNCiAgIGNtLmNvdXJzZSA9IGMuaWQgQU5EDQogICBjYzEuaWQgPSBjLmNhdGVnb3J5IEFORA0KICAgbC5vYmplY3R0YWJsZSA9IG0ubmFtZSBBTkQNCiAgIGwub2JqZWN0aWQgPSBjbS5pbnN0YW5jZSBBTkQNCiAgIGwudXNlcmlkID0gdS5pZCBBTkQNCiAgIGwuYWN0aW9uID0gJ3ZpZXdlZCcNCiAgIA0KICAgPCUlRklMVEVSUyUlPg0KR1JPVVAgQlkNCiAgICBDT05DQVQoY20uaWQsICctJywgdS5pZCkiO3M6MTU6InF1ZXJ5cm90YXRlY29scyI7czowOiIiO3M6MTY6InF1ZXJ5cm90YXRlcGl2b3QiO3M6MDoiIjtzOjE4OiJxdWVyeXJvdGF0ZW5ld2tleXMiO3M6MDoiIjtzOjEyOiJzcWxwYXJhbXZhcjEiO3M6MDoiIjtzOjE0OiJzcWxwYXJhbWxhYmVsMSI7czowOiIiO3M6MTM6InNxbHBhcmFtdHlwZTEiO3M6NjoiY2hvaWNlIjtzOjE1OiJzcWxwYXJhbXZhbHVlczEiO3M6MDoiIjtzOjEyOiJzcWxwYXJhbXZhcjIiO3M6MDoiIjtzOjE0OiJzcWxwYXJhbWxhYmVsMiI7czowOiIiO3M6MTM6InNxbHBhcmFtdHlwZTIiO3M6NjoiY2hvaWNlIjtzOjE1OiJzcWxwYXJhbXZhbHVlczIiO3M6MDoiIjtzOjEyOiJzcWxwYXJhbXZhcjMiO3M6MDoiIjtzOjE0OiJzcWxwYXJhbWxhYmVsMyI7czowOiIiO3M6MTM6InNxbHBhcmFtdHlwZTMiO3M6NjoiY2hvaWNlIjtzOjE1OiJzcWxwYXJhbXZhbHVlczMiO3M6MDoiIjtzOjEyOiJzcWxwYXJhbXZhcjQiO3M6MDoiIjtzOjE0OiJzcWxwYXJhbWxhYmVsNCI7czowOiIiO3M6MTM6InNxbHBhcmFtdHlwZTQiO3M6NjoiY2hvaWNlIjtzOjE1OiJzcWxwYXJhbXZhbHVlczQiO3M6MDoiIjtzOjk6InRhYmxldHlwZSI7czo2OiJsaW5lYXIiO3M6MTI6Im91dHB1dGZpZWxkcyI7czozNzoiY2MxO3NuO2ZuO3J0eXBlO3JuYW1lO3ZpZXdlcztsYXN0dmlldyI7czoxMToiZmllbGRsYWJlbHMiO3M6NTU6IkNhdMOpZ29yaWU7Q29kZTtDb3VycztUeXBlO1Jlc3NvdXJjZTtWdWVzO0Rlcm5pw6hyZSB2dWUiO3M6MTM6Im91dHB1dGZvcm1hdHMiO3M6MjA6IiVzOyVzOyVzOyVzOyVzOyVkOyVEIjtzOjg6InBhZ2VzaXplIjtzOjA6IiI7czoxNToidXNlbG9jYWxjYWNoaW5nIjtzOjE6IjEiO3M6MTA6ImNhY2hpbmd0dGwiO3M6MDoiIjtzOjEyOiJjbGVhbmRpc3BsYXkiO3M6MToiMSI7czoyMjoiY2xlYW5kaXNwbGF5dXB0b2NvbHVtbiI7czoxOiIyIjtzOjg6InNvcnRhYmxlIjtzOjE6IjAiO3M6MTU6InNwbGl0c3Vtc29uc29ydCI7czowOiIiO3M6MTI6InZlcnRpY2Fsa2V5cyI7czowOiIiO3M6ODoiaG9yaXprZXkiO3M6MDoiIjtzOjE1OiJ2ZXJ0aWNhbGZvcm1hdHMiO3M6MDoiIjtzOjExOiJob3JpemZvcm1hdCI7czowOiIiO3M6Nzoic3BsaXRvbiI7czowOiIiO3M6OToiaG9yaXpzdW1zIjtzOjE6IjAiO3M6ODoidmVydHN1bXMiO3M6MToiMCI7czoxNDoidmVydGljYWxsYWJlbHMiO3M6MDoiIjtzOjEwOiJob3JpemxhYmVsIjtzOjA6IiI7czoxMToicGFyZW50c2VyaWUiO3M6MDoiIjtzOjEwOiJ0cmVlb3V0cHV0IjtzOjA6IiI7czoxNzoidHJlZW91dHB1dGZvcm1hdHMiO3M6MDoiIjtzOjc6ImZpbHRlcnMiO3M6NjE6ImMuZnVsbG5hbWUgYXMgZm47Q09OQ0FUKHUubGFzdG5hbWUsICcgJywgdS5maXJzdG5hbWUpIGFzIHVzZXIiO3M6MTI6ImZpbHRlcmxhYmVscyI7czoxNzoiQ291cnM7VXRpbGlzYXRldXIiO3M6MTQ6ImZpbHRlcmRlZmF1bHRzIjtzOjExOiJGSVJTVDtGSVJTVCI7czoxMzoiZmlsdGVyb3B0aW9ucyI7czo1OiJzeDtzeCI7czo3OiJudW1zdW1zIjtzOjA6IiI7czoxMzoibnVtc3VtZm9ybWF0cyI7czowOiIiO3M6MTI6Im51bXN1bWxhYmVscyI7czowOiIiO3M6OToiZ3JhcGh0eXBlIjtzOjQ6ImxpbmUiO3M6MTA6InhheGlzZmllbGQiO3M6MDoiIjtzOjEwOiJ4YXhpc2xhYmVsIjtzOjA6IiI7czo3OiJ5c2VyaWVzIjtzOjA6IiI7czoxNDoieXNlcmllc2Zvcm1hdHMiO3M6MDoiIjtzOjEyOiJzZXJpZXNsYWJlbHMiO3M6MDoiIjtzOjQ6InltaW4iO3M6MDoiIjtzOjQ6InltYXgiO3M6MDoiIjtzOjExOiJ0aWNrc3BhY2luZyI7czowOiIiO3M6MTA6InlheGlzbGFiZWwiO3M6MDoiIjtzOjEwOiJncmFwaHdpZHRoIjtzOjM6IjQ1MCI7czoxMToiZ3JhcGhoZWlnaHQiO3M6MzoiMjUwIjtzOjEwOiJzaG93bGVnZW5kIjtzOjE6IjAiO3M6NzoibWFwdHlwZSI7czo3OiJST0FETUFQIjtzOjQ6Inpvb20iO3M6MToiNiI7czoxMDoiZGF0YXRpdGxlcyI7czowOiIiO3M6MTM6ImRhdGFsb2NhdGlvbnMiO3M6MDoiIjtzOjk6ImRhdGF0eXBlcyI7czowOiIiO3M6MzoibGF0IjtzOjE6IjAiO3M6MzoibG5nIjtzOjE6IjAiO3M6MTM6InNob3dsb3dlcmJhbmQiO3M6MToiMSI7czoxMzoidXBwZXJiYW5kdW5pdCI7czo1OiJNT05USCI7czoxMzoibG93ZXJiYW5kdW5pdCI7czo0OiJZRUFSIjtzOjE4OiJ0aW1lbGluZWV2ZW50dGl0bGUiO3M6MDoiIjtzOjE4OiJ0aW1lbGluZWV2ZW50c3RhcnQiO3M6MDoiIjtzOjE2OiJ0aW1lbGluZWV2ZW50ZW5kIjtzOjA6IiI7czoxNzoidGltZWxpbmVldmVudGxpbmsiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWV2ZW50ZGVzYyI7czowOiIiO3M6MTQ6InRpbWVsaW5lY29sb3JzIjtzOjA6IiI7czoxODoidGltZWxpbmVjb2xvcmZpZWxkIjtzOjA6IiI7czoxNzoidGltZWxpbmVjb2xvcmtleXMiO3M6MDoiIjtzOjg6ImNyb25tb2RlIjtzOjk6Im5vcmVmcmVzaCI7czo4OiJjcm9uaG91ciI7czowOiIiO3M6NzoiY3Jvbm1pbiI7czowOiIiO3M6MTM6ImNyb25mcmVxdWVuY3kiO3M6NToiZGFpbHkiO3M6ODoibWFrZWZpbGUiO3M6MToiMSI7czoxMDoiZmlsZW91dHB1dCI7czowOiIiO3M6MTc6ImZpbGVvdXRwdXRmb3JtYXRzIjtzOjA6IiI7czoxMDoiZmlsZWZvcm1hdCI7czozOiJDU1YiO3M6MTU6ImZpbGVzcWxvdXR0YWJsZSI7czowOiIiO3M6MTI6ImZpbGVsb2NhdGlvbiI7czowOiIiO3M6MjE6ImZpbGVwYXRoYWRtaW5vdmVycmlkZSI7czowOiIiO3M6ODoic2F2ZXZpZXciO3M6MjM6IkVucmVnaXN0cmVyIGV0IGFmZmljaGVyIjtzOjk6InNxbHBhcmFtcyI7TjtzOjk6ImlzcnVubmluZyI7aTowO3M6ODoibGFzdGNyb24iO2k6MDt9
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