Run Report Filter
A Run Report Filter is used in a Run Report Function to add a filter to the data. These can be created in the Insert Run Report function wizard, or they can be created manually.
There are three parameters in the function.
Parameter | Description |
---|---|
Field | The name of the field returned in the SQL. |
Operator | The operator. |
Value | The value of the Field |
Example: =RW_Run_Report_Filter(“Bank Account Number”,”Equals”,”10271-17621-619″)
Operators
The full list of valid operators are:
- Equals
- Not equal to
- Less than
- Greater than
- Less or equal
- Greater or equal
- Contains
- Does not contain
- Starts with
- Is NULL
- Is Not NULL
- Advanced
Advanced Operator
The Advanced operator allows for additional functionality.
Type | Example Value | Description |
---|---|---|
Multiple value or list | 1000,2000,3000 | Specify multiple values separated by a comma to implement an IN statement. e.g. IN (1000,2000,3000) |
Return all values | %, null | To dynamically use a single parameter to return filtered results or all values on request, you can specify “%, null” as the value. This will return all rows where the criteria is either null or contains a value. |
Wildcard list | %test,%train,%temp | Specify a list with wildcards to return all values that meet each criteria e.g. the example value will return all rows where the value ends with either test, train or temp. |
List with an exclude | %test%,%train%,~work train,%temp% | Specify a list with (or without) wildcards, and exclude values that don’t need to be returned e.g. all test, train and temp values will be returned except for the value work train. |