[{TableOfContents }]

!!!MAINTAIN WHERE CLAUSES BY TABLE

The Maintain Where Clauses by Table (IMDAO) form is used maintain the Where Clause by specific tables within the application. 

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] table.
\\  \\
----
!! Where Clause tab

;[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 |X_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. This field is not normally used. 
;[Column|COLUMN_NAME]:This field allows you to define the filters to be used with the Where Clause. 
%%information You may use more than one filter on a Where Clause. If you do use multiple filter 
statements, they are joined by ‘and’ in the statement.\\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. 
;[Value|VALUE]:This field completes the SQL statement of the previous field.\\  \\This field holds information used to filter the where clause against. For example, it may be "Active" if the where clause is to filter a list of employees based on their employment status.

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|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. 
\\  \\
----
!!Cache tab 
 
;[Cache Status |]:
;[Cached Columns |]:
;[Clear Table Data |]:
;[Clear All Cached Tables |]:
;:%%warning Only use in the most extreme cases%%
\\   \\
----
!!Form Usage tab
;[Function|FUNCTION_NAME]:
;[MFN Usage|FUNCTION_USAGE]:
;[Join Clause|JOIN_CLAUSE]:
;[Where Clause|WHERE_CLAUSE]:
;[MFT Usage|]:

;[Create|CREATE_ALLOWED]/[Retrieve|RETRIEVE_ALLOWED]/[Update|UPDATE_ALLOWED]/[Delete Allowed|DELETE_ALLOWED]:
\\  \\
----
!!LOV Usage tab
;[LOV Code|LOV_CODE]:
;[LOV Usage|LOV_USAGE]:
;[Where Clause|WHERE_CLAUSE]:
;[Exclude From Cache|]:

[CLEANUP]