Overview
Now that you’ve learned some basic filter clause operators from this knowledge article: https://silverband.atlassian.net/wiki/spaces/DPG/pages/1457127488, you can add more complex filters by using the operators mentioned on this article. The following operators are mostly used to compare two fields.
Navigation
Comparison Operators
Like
Like is a wildcard value. This will return values that contain a pattern match (partial keyword matching).
Example 1
“Suburb” Like B (will return Broadview, Broadmeadows, Brighton)
Example 2
“UnitCode” Like ACC (will return all unit codes with “Acc” keyword, like Accounting101, etc.)
Not Like
Displays records if a condition is not TRUE or don’t match the selected pattern match.
Example 1
“Surname” NOT LIKE Smith (will return other surnames like: Jones, Brown, Davies except for Smith)
Example 2
“Student Number” NOT LIKE A (will return all other student numbers except for the ones that starts with A)
Field Equals (=)
Compares the contents of one field if the same or equal to another field.
Example 1
“Country” Field Equals (=) “Billing Country” will return data which has the same country and billing country information
Sample Output
Field Not Equals !=
Will return data or information with a field not equal to the other field.
Example 1
“Country” Field Not Equals (=) “Billing Country” will return data which has a country not equal or the same as the billing country
Sample Output
Field Greater Than (>)
Will return data or information with a field greater than the other field.
Example 1
“Withdrawal Date” Field Greater Than (>) “Dest Census Date will return data which has a withdrawal date greater than the Dest Census Date.
Sample Output
Field Less Than (<)
Will return data or information with a field less than the other field.
Example 1
“Amount Paid” Field Less Than (<) “Amount Due” will return data which has an amount paid less than the amount due.
Sample Output
Field Greater Than Equal To (>=)
Will return data or information with a field greater or equal to the other field. The difference with this and the Field Greater Than (>) operator is that this would include the field which is also equal to the other field.
Example 1
“Withdrawal Date” Field Greater Than Equal To (>=) “Dest Census Date will return data which has a withdrawal date greater than or equal to the Dest Census Date.
Sample Output
Field Less Than Equal To (<=)
Will return data or information with a field less than or equal to the other field. The difference with this and the Field Less Than (>) operator is that this would include the field which is also equal to the other field.
Example 1
“Amount Paid” Field Less Than Equal To (<=) “Amount Due” will return data which has an amount paid less than or equal to the amount due.
Sample Output
Advanced Report Builder | Order By Clauses | Alternative Data Formats | Bulk Student Select | Complex Filter Clause Operators | Nested Operators Using Brackets | User-Defined Parameters | Summarise Data | Generic Report Query