Overview

Adding filter clauses avoid the need to extract out all data from Paradigm in favour of targeting just the records that are desired. This is both to minimise the time taken to generate a report and also remove the need for manually editing (removing rows) from the output before it is ready to support business decision making.

Basic Filter Clause Operators

---

Equals (=)

For this operator the data within the column name has to be an exact match.

Example 1

“Credit points” = 100 Only “Postal Code” = 3153 (only records with the exact match (3153) will be returned in the data set

Image Removed

Equals (=)

For this operator the data within the column name has to be an exact match.

Example

“Credit points” = 100 Only )

Image Added

Example 2

“Course Accredited” = YES (only records with the exact match (YES) will be returned in the data set)

Image RemovedImage Added

Not Equal !=

For this operator the data within the column name can not be an exact match.

Example : “Credit points” not = 100 Records with every number OTHER then 100 1

“Postal Code” Not Equal ! = 3153 (records with every postcode OTHER than 3153 will be returned)

 Image Added

Greater Than (>)

Normally used for numeric values like date, credit points. Example: “Credit Points” > 100 (values returned will start from 101) “Start Date” > 01/01/2018 Return values greater than what has been set.

Example 1

“Start Date” Greater Than (>) 2020-01-01 (values returned will start

from 02/01/2018

after 2020-01-01)

 Image Added

Less Than (<)

Normally used for numeric values like date, credit points.

Example: “Credit Points” < 100 (Values returned will be up to and including 99) “Start Date” < 01/01/2018 (values returned will be up to and including 31/12/2017)

 

Greater Than Equal to

Return values less than what has been set.

Example 1

“Start Date” Less Than (<) 2020-01-01 (values returned before 2020-01-01)

Image Added

Greater Than Equal To (>=)

Normally used for numeric values like date, credit pointsExample: “Credit Points” > 100 (values returned will start from 100) “Start Date” > 01/01/2018 . Return values greater than and equal to what has been set.

Example 1

“Start Date” Greater Than Equal To (>=) 2020-01-01 (values returned will start from 2020-01

/

-01

/2018

)

v

 Image Added

Less

than

Than Equal

to

To (<=)

Normally used for numeric values like date, credit points

Example: “Credit Points” < 100 (Values returned will be up to and including 100) “Start Date” < 01/01/2018 (values returned will be up to and including 01/01/2018)

 . Return values less than and equal to what has been set.

Example 1

“Start Date” Less Than Equal To (<=) 2020-01-01 (values returned on or before 2020-01-01)

Image Added

In

IN is normally used when selecting from predefined options from the drop down box

Example : “Course Enrolment Status Id” In ENROLLED All 1

“Course Level” In Graduate (all records with a

Course enrolment status of enrolled

course level “Graduate” will be returned)

 Image Added

Not In

NOT IN is normally used when selecting from predefined options from the drop down box, and it it will choose which of the predefined options should be specifically excluded from the results.

Example : “Course Enrolment Status Id” NOT IN ENROLLED All records who are in any status other than ENROLLED will be returned1

“Course Level” Not In Graduate (all records with a course level “Graduate” will not be returned)

Image Added

Nested Filters

Brackets

Conditions

Base Report Parameters

Nested Operators Using Brackets

Configuring Report Parameter Screen

• Appear on form

• Form label

• Mandatory

Workflow

Status
colour Green title 1

In the Bracket Open column, select a bracket if you are adding to add nested clauses.

Status
colour Green title 2

Select the field name you want to add a filter clause to under the Column Name.

Status
colour Green title 3

Select an operator under the Operator column required for the field you chose under the Column Name.

Status
colour Green title 4

Enter the value you want for the column name to be true against the comparison operator selected.

Status
colour Green title 5

Select a condition or logical operator (AND or OR) if you want to add another line of clause or condition.

Sample Clause:

Info
INFO: In the sample clause above, all data within the specified start and end date (2018-09-26 and 2021-09-26), and with a Completed unit enrolment status Id will be displayed.

---

---

_{Introduction to Report Builder | Step 1 - Select a Base Report | Step 2 - Add and Remove Fields | Step 3 - Rename and Reorder Fields | Step 4 - Add Filter Clauses | Step 5 - Save Report}