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

Workflow

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

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

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

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

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

Sample Clause:

_{Base Reports | Report Columns | Filter Clauses | User Defined Parameters | Order By Clauses | Generic Report Query | Summarise Data | Save Report | Format Report}