Documentation Moodle ActiveProLearn - blocks:dashboard:querycatalogue

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) Yearly logins curve / year / profile variable SELECT CONCAT(FROM_UNIXTIME(l.timecreated, '%Y-%m'), '-', uid.data) as pk, FROM_UNIXTIME(l.timecreated, '%Y-%m') as month, uid.data as fonction, COUNT(*) as cnx, FROM_UNIXTIME(l.timecreated, '%Y') as year

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) Yearly histogram of logins by course and by month Rendering with filters by course and by year, and output data by month, distinct users and course visits 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

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) Users who have never logged in, by cohort Displays the list of users who have never logged in, by cohort, with as output data the categories and subcategories of the courses concerned, the shortnames and the courses, and the cohort names. For users: last name, first name, email, username, role and a custom profile field on their function in Moodle)

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) Resource popularity table by cohort Displays a table of resource popularity by cohort. Rendered in output columns showing the course category and subcategory, the resource type and name with the number of views and the date of last view per resource, as well as the sections and subsections where they appear.

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) Registrations per day Displays a column with the date, and one with the number of users registered on the platform on that date. SELECT FROM_UNIXTIME(u.timecreated,"%Y-%m-%d") as day, FROM_UNIXTIME(u.timecreated,"%M") as month, COUNT(*) as nbrusers

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) Users by authentication method SELECT u.auth as auth, COUNT(*) as users FROM {user} u WHERE deleted = 0 AND suspended = 0 AND username != 'guest' <%%PARAMS%%> GROUP BY u.auth Configuration

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) List of groups 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

Generic Query Catalogue

Anonymous (anonymous@undisclosed.example.com) — 2026-11-13T21:01:09+00:00

Generic Query Catalogue Dashboard Block (Dashboard Element) List of resources viewed by users * Currently over 5 resource types: url, quizzes, assignments, page, folder * Filtering by course * Filtering by user 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 …