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

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:

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%%