MAINTAIN WHERE CLAUSES#
The Maintain Where Clauses (IMWC) form allows you to create and edit Where Clauses within the system. It is used to filter data on forms, approval processes, LOV’s and people lists.
In order to use Where Clauses, you should be familiar with SQL.The definition data for the Maintain Where Clauses screen is stored in the P2K_AM_WHERE_CLAUSES and P2K_AM_CONDITIONS tables.
- Data Source
- This field indicates the data source that the Where Clause will be attached. (Mandatory)
- e.g. The Positions table used for an LOV that the Where Clause will then filter.
- Where Clause
- This field identifies the Where Clause.
- Usage
- This field will indicate if the Where Clause is Pre-loaded (McKessonHigh Line provided),
- Description
- This field provides a short description of the Where Clause.
- Type
- This field categorizes the Where Clause into a specific type.
- For example: Ad Hoc, Predefined
- Predefined
- If the Where Clause is pre-loaded, its predefined name will appear in this field.
- Column Name
- This field allows you to define the filters to be used with the Where Clause.
- e.g. You can use multiple columns to return a Positions LOV that will be filtered first by department, next by active status, and finally by date.
- Operator
- This field allows you to provide an SQL statement to further filter the information.
- e.g. equal to, not equal to, less than, greater than.
- Value
- This field completes the SQL statement of the previous field.
- e.g. active status, Finance department.
The Column, Operator and Value fields are used together to create a precise filter for information. For example, if you wished to only see in the LOV positions that are in the Finance department, you would insert the following information in those fields:
- Column = ID.DPS_ID
- Operator = equal to
- Value = Finance
- Description
- This field will provide a full description of how the Where Clause operates.
- Physical Column Name
- Physical Condition
- Test Where Clause
- This button allows you to test the Where Clause to see if it returns the correct information in a timely manner.
