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:
Using VariablesVariables can be used anywhere inside of your SQL query.
Using FiltersWhen using a filter you need at least one static WHERE condition then you list one or more filters. For exampleWHERE 1%%FILTER_COURSES:c.id%%
Read the full article by Jonathan Moore here.