This page (revision-25) was last changed on 26-Nov-2021 10:22 by JAiken

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
25 26-Nov-2021 10:22 5 KB JAiken to previous
24 26-Nov-2021 10:22 4 KB JEscott to previous | to last
23 26-Nov-2021 10:22 4 KB JEscott to previous | to last
22 26-Nov-2021 10:22 4 KB JEscott to previous | to last
21 26-Nov-2021 10:22 4 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
IMDAO
IMDAO

Version management

Difference between version and

At line 5 changed 3 lines
The definition data for the Maintain Where Clauses by Table screen is stored in the [P2K_AM_DATA_ACCESS_OBJECTS], [P2K_AM_WHERE_CLAUSES], [P2K_AM_CONDITIONS], [P2K_AM_FORM_TABLE_USAGES], and [P2K_AM_LIST_OF_]
;[Data Source|]:
The definition data for the Maintain Where Clauses by Table screen is stored in the [P2K_AM_DATA_ACCESS_OBJECTS], [P2K_AM_WHERE_CLAUSES], [P2K_AM_CONDITIONS], [P2K_AM_FORM_TABLE_USAGES], and [P2K_AM_LIST_OF_VALUES]
At line 12 changed 11 lines
Where Clause|]:
This field identifies the Where Clause.
Description|]:
This field provides a short description of the Where Clause.
Usage |]:
This field will indicate if the Where Clause is Pre-loaded (system provided), User Defined or Obsolete.
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.
;[Where Clause|WHERE_CLAUSE_CODE]:This field identifies the Where Clause.
;[Description|DESCRIPTION]: This field provides a short description of the Where Clause.
;[Usage|WHERE_CLAUSE_USAGE]:This field will indicate if the Where Clause is Pre-loaded (system provided), User Defined or Obsolete.
;[Type |DATA_SOURCE_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|COLUMN_NAME]:This field allows you to define the filters to be used with the Where Clause.
At line 29 changed 6 lines
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.
;[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 8 lines
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|]:
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|]:
;[Test Where Clause |]:This button allows you to test the Where Clause to see if it returns the correct information in a timely manner.
At line 49 changed 4 lines
Cache Status |]:
Cached Columns |]:
Clear Table Data |]:
Clear All Cached Tables |]:
;[Cache Status |]:
;[Cached Columns |]:
;[Clear Table Data |]:
;[Clear All Cached Tables |]:
At line 54 removed one line
At line 57 changed 5 lines
Function|]:
MFN Usage|]:
Join Clause|]:
Where Clause|]:
MFT Usage|]:
;[Function|]:
;[MFN Usage|]:
;[Join Clause|]:
;[Where Clause|]:
;[MFT Usage|]:
At line 66 changed 4 lines
LOV Code|]:
LOV Usage|]:
Where Clause|]:
Exclude From Cache|]:
;[LOV Code|]:
;[LOV Usage|]:
;[Where Clause|]:
;[Exclude From Cache|]:
This page (revision-25) was last changed on 26-Nov-2021 10:22 by JAikenTop