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: “Credit points” = 100 Only records with the exact match will be returned in the data set
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 will be returned
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 (values returned will start from 02/01/2018)
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 (>=)
Normally used for numeric values like date, credit points
Example: “Credit Points” > 100 (values returned will start from 100) “Start Date” > 01/01/2018 (values returned will start from 01/01/2018)v
Less than Equal 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)
In
IN is normally used when selecting from predefined options from the drop down box
Example: “Course Enrolment Status Id” In ENROLLED All records with a Course enrolment status of enrolled will be returned
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 returned
Base Report Parameters
Nested Operators Using Brackets
Configuring Report Parameter Screen
Appear on form
Form label
Mandatory
Base Reports | Report Columns | Filter Clauses | User Defined Parameters | Order By Clauses | Generic Report Query | Summarise Data | Save Report | Format Report