This page (revision-15) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 26-Nov-2021 10:22 3 KB Kevin Higgs to previous
14 26-Nov-2021 10:22 3 KB jmyers to previous | to last
13 26-Nov-2021 10:22 3 KB JAiken to previous | to last
12 26-Nov-2021 10:22 3 KB RForbes to previous | to last
11 26-Nov-2021 10:22 3 KB JEscott to previous | to last FORMATTED EQUALS WHERE CLAUSE OPERATOR ==> FORMATTED EQUALS WC OPERATOR
10 26-Nov-2021 10:22 3 KB JEscott to previous | to last
9 26-Nov-2021 10:22 3 KB JEscott to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JAiken to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JEscott to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IMWC
IMWC

Version management

Difference between version and

At line 3 changed 5 lines
The Maintain Where Clauses (IMWC) form is used to filter data on forms, approval processes, LOV’s and people lists.
This section explains the purpose of Where Clauses within the application and the Maintaining Where Clause screen.
In order to use Where Clauses, you should be familiar with SQL.
The Maintain Where Clauses screen allows you to create and edit Where Clauses within the
system.
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.
%%information 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.
At line 9 changed 6 lines
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),
;[Data Source|DATA_SOURCE_NAME]: 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|WHERE_CLAUSE_CODE]:This field identifies the Where Clause.
;[Usage|WHERE_CLAUSE_USAGE]:This field will indicate if the Where Clause is Pre-loaded (McKessonHigh Line provided),
At line 16 changed 7 lines
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.
;[Description|DESCRIPTION]:This field provides a short description of the Where Clause.
;[Type|CONDITION_TYPE]:This field categorizes the Where Clause into a specific type.
;:For example: Ad Hoc, Predefined
;[Predefined|PREDEFINED_CONDITION_CODE]:If the Where Clause is pre-loaded, its predefined name will appear in this field.
At line 24 changed 2 lines
Column
This field allows you to define the filters to be used with the Where Clause.
;[Column Name|COLUMN_NAME]:This field allows you to define the filters to be used with the Where Clause.
At line 28 changed 7 lines
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.
;: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|COMPARISON_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|VALUE]:This field completes the SQL statement of the previous field.
;:e.g. active status, Finance department.
At line 37 changed 6 lines
Column = ID.DPS_ID
Operator = equal to
Value = Finance
Description
This field will provide a full description of how the Where Clause operates.
Test Where Clause This button allows you to test the Where Clause to see if it returns the correct information in a timely manner.
* Column = ID.DPS_ID
* Operator = equal to
* Value = Finance
;[Description|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.
This page (revision-15) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop