Scripted Reports - Adding/editing filters

Report filters

Report filters narrow the data set that is shown in the report, which makes the reporting process faster - both in the processing time taken to return results and the time needed to find the data you are looking for.

Reports can be filtered for any type of data available in that report type, and the report results can be filtered further by any of the columns displayed in the report.

The available filters come in several categories:

Category	Description	Mandatory	Report type
User	User profile data and site access records	Yes	All
Course	Course information	No	All except SCORM Interaction report
Enrolment	Course access, completion and grades	No	All
Activity	Activity details, completion and grades	Yes	Activity report
SCORM	Details about a SCORM activity	Yes	SCORM report and SCORM Interaction report
SCORM Interaction	List of all existing SCORM interaction identifiers	No	SCORM Interaction report
SCORM Objective	List of all SCORM objective identifiers	No	SCORM Interaction report
Face-to-face	Details about a face-to-face activity and it's attendance by the user	Yes	Face-to-face report

Adding filters

1. To see a list of all filter types available, select one of the Show advanced buttons

2. Choose a field, an operator, enter the data to filter against, and select Add ... filter. For example, to show only courses Induction courses you might choose:

• Course full name
• Starts with
• Induction

3. The page will refresh and the new filter will appear in its section

4. Repeat the above until you have all the required filters. Select Continue at the bottom of the page once complete.

Removing Filters

Every report comes with three filters that are added by default. These filter out any inactive, deleted or suspended users so that only users with active accounts are shown in reports.

1. To remove these - or any other filter you have added - tick the ones you want to remove and click Remove selected

2. If you want to remove all the filters in a section, then click Remove all ... filters instead.

Join operators

By default, multiple filters use AND logic. For example, in the example below the report will only show induction courses that started after 2013

 

You can use more than instance of the same filter type but they could conflict with each other, a course's name couldn't start with "Induction" AND with "Mandatory"

By changing the join condition to OR you can search for multiple hits in the same field. In the example below, the report would show all induction courses and all mandatory courses that started after 2013.

Please note

• You must click Update join conditions or no condition changes will be saved
• You can only use OR between two or more of the same filter type.