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