List of All Variables and Filters for Moodle's Configurable Reports Plugin

3773

Jonathan Moore, the founder of  eLearning Consultancy has shared the list of all variables and filters which can be used with Configurable Reports plugin in creating various reports.
Configurable Reports is a popular plugin for Moodle that allows administrators to create custom reports for Moodle and make them available to their end users.
The list of all variables and filters is as follows:

Post Pages - Post Inline - WIRIS

Variables

%%CATEGORYID%%
%%COURSEID%%
%%CURRENTUSER%%
%%DEBUG%%
%%FILTER_VAR%%
%%STARTTIME%%’,’%%ENDTIME%%
%%USERID%%
%%WWWROOT%%

Filters

%%FILTER_CATEGORIES:
%%FILTER_COURSEMODULEID:
%%FILTER_COURSEMODULEFIELDS:
%%FILTER_COURSEMODULE:
%%FILTER_COURSES:
%%FILTER_COURSEENROLLEDSTUDENTS:
%%FILTER_USERS:
%%FILTER_ROLE:
%%FILTER_SEARCHTEXT:
%%FILTER_SEMESTER:
%%FILTER_STARTTIME:
%%FILTER_ENDTIME:
%%FILTER_SUBCATEGORIES:
%%FILTER_COURSEUSER:
%%FILTER_SYSTEMUSER:
%%FILTER_YEARHEBREW:
%%FILTER_YEARNUMERIC:

Using Variables

Variables can be used anywhere inside of your SQL query. 

Using Filters

When using a filter you need at least one static WHERE condition then you list one or more filters. For example
WHERE 1
%%FILTER_COURSES:c.id%%
Read the full article by Jonathan Moore here.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.