Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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.

NOTE: In this column, the field or column name you choose would not necessarily be included in your report output. You can choose the field here that could help you filter your result.

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:

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.


  • No labels