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.
Comments