Comparison Methods
From Alchemex 7.1
Home >
Comparison Methods
Comparison Methods are used with filters and parameters to refine or limit the rows that are returned to a report. Note that when doing string comparisons, the comparisons may or may not be case sensitive. This will depend on the underlying data source. An example for each comparison method is shown below:
| Comparison Method | Example | Search Objective | Alpha/Numeric |
|---|---|---|---|
| Equal To | South Africa | True when the expression contains 'South Africa' | Both |
| Greater Than | 100 | True when the expression is greater than 100 | Both |
| Less Than | 100 | True when the expression is less than 100 | Both |
| Greater Than Or Equal To | 100 | True when the expression is greater than or equal to 100 | Both |
| Less than Or Equal To | 100 | True when the expression is less than or equal to 100 | Both |
| Is Like | %S%3% | True when the expression is contains an 'S' and a '3' (but not before the 'S') | Alpha |
| Not Equal To | Ken | True when the expression is not equal to 'Ken' | Both |
| Begins With | Darang | True when the expression begins with 'Darang' | Alpha |
| Ends With | K | True when the expression ends with 'K' | Alpha |
| Contains | Woodridge | True when the expression contains the text 'Woodridge' | Alpha |
| Does Not Begin With | doc | True when the expression does not begin with 'doc' | Alpha |
| Does Not End With | s | True when the expression does not end with 's' | Alpha |
| Does Not Contain | @ | True when the expression does not contain '@' symbol | Alpha |
| Is Not Null | True when the expression is Not Null | Both | |
| Is Null | True when the expression is Null | Both | |
| Is In | 1,3,4 | True when the field is equal to one of the values in the comma separated list | Both |
| Is Not In | 1,3,4 | True when the field is not equal to any of the values in the comma separated list | Both |
| Is Not Like | %S%3% | True when the expression does not contain an 'S' and a '3' (but not before the 'S') | Alpha |
| Is In Sub Query | Report ID | True when the results from a field are contained within the results from the specified Sub Query Report | |
| Is Not In Sub Query | Report ID | True when the results from a field are not contained within the results from the specified Sub Query Report | |
| Is In Parallel Query | Report ID | True when the results from a field are contained within the results from the specified Sub Query Report | |
| Is Not In Parallel Query | Report ID | True when the results from a field are not contained within the results from the specified Sub Query Report |