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 definition |
| Operator | The operator |
| Value | The value of the Field |
Example: =RW_Run_Report_Filter(“Customer Number”,”Equals”,”10100005″)
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 include a multiple values as a list. |
| 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. |