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 2 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


  • No labels