| |
EDI Viewer - Filters |
Filters are used to display the data you want to see based on a filter expression you enter. Filters can be an extremely powerful way for you to analyze your data and find any detail you may want. A filter expression can be a very simple expression or a complex mathematical calculation.
An important note to remember about filters is that they only filter the data that has been retrieved from the database. If you retrieved all data for invoice 1000, you could then filter the data to see only facility code 2222. If you retrieved the data for invoice 1000 for facility code 1111, you would only have data for facility 1111 and filtering the data for facility code 2222 would result in the report showing no data.
The Filter window you see has the following areas:
Filter expressions are boolean expressions that must
evaluate to TRUE or FALSE.
To Remove a filter, delete the filter expression and click Ok.
| Expression | Description |
|---|---|
| charge_type = 'CROWN ROYALTY' and crown_interest >= 95.00 and facility = 'GP-1001' | Displays data for facility code GP-1001 where the crown interest is greater than or equal to 95% and the charge type is CROWN ROYALTY. |
| Emp_sal < 50000 | Displays data for employees with salaries less than $50,000 |
| Salary > 50000 AND Dept_id BETWEEN 400 AND 700 | Displays data for employees in departments 400, 500, 600, and 700 with salaries greater than $50,000 |
| Month(Bdate) = 9 OR Month(Bdate) = 2 | Displays data for people with birth dates in September or February |
| Match ( client_name, "[ ^ABC ]" ) | Displays data for clients whose name begins with A, B, or C |
| crown_interest = 100 | Displays data where the crown interest rate is equal to 100%. |
| stream_code_id LIKE 'WI-10020%' | Displays data where the stream code id starts with WI-10020 and has any characters after it. This would be any wells in LSD 20 whose UWI starts with 100. |
| Match ( stream_code_id, 'WI-10020' ) | Displays data where the stream code id starts with WI-10020 and has any characters after it. This would be any wells in LSD 20 whose UWI starts with 100. |
To ensure predictable results, all operators in an expression are evaluated in a specific order of precedence. When the operators have the same precedence, they are evaluated from left to right.
The following table lists the operators in descending order of precedence:
| Operator | Purpose |
|---|---|
| ( ) | Grouping |
| ^ | Exponentiation |
| *, / | Multiplication and division |
| +, - | Addition and subtraction; string concatenation |
| IN,LIKE,BETWEEN | SQL SELECT statement conditions |
| NOT | Logical negation |
| =, >, <, <=, >=, <> | Relational operators |
| AND,OR | Logical and and logical or |