This page (revision-22) 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
22 26-Nov-2021 10:22 973 bytes jaiken to previous HighLine. IMLQ ==> IMLQ
21 26-Nov-2021 10:22 982 bytes jaiken to previous | to last

Page References

Incoming links Outgoing links
IMLQ
IMLQ

Version management

Difference between version and

At line 1 changed one line
!!!DEFINE LOV QUERIES
[{TableOfContents }]
At line 3 changed one line
The Define LOV Queries (IMLQ) screen is used to define List of Value (LOV) Queries that are used in [{$applicationname}] throughout all screens.
!!!Maintain Report List Queries
The Maintain Report List (IMLQ) form is used to maintain the query selection criteria used to create report lists within Personality.
At line 5 changed one line
IMLQ entries that start with IMPV_xxxx are used to determine the report list used by the various reports. This is especially true of those reports that are either Oracle Reports or are primarily processes that are executed on the data base server (like [UPCALC]). The various parameters and filters for these processes, as defined in IMPM, would add additional conditions to the SELECT statement which further refines the report list.\\
The data is maintained on the [P2K_AM_LOV_QUERIES] and [P2K_AM_LOV_QUERY_COLUMNS] tables.
At line 7 changed 14 lines
The definition data for the Define LOV Queries screen is stored in the [P2K_AM_LOV_QUERIES] and [P2K_AM_LOV_QUERY_COLUMNS] tables.\\
;[LOV|COLUMN_NAME]:This field identifies the LOV that is having its query defined.
;[Title|LOV_TITLE]:This field identifies the LOV by its
;[Description|DESCRIPTION]:This field provides an abbreviated form of the table name.
;[Test Query|]:
;[Query Text|LOV_QUERY_TEXT]:
;[View Width|VIEW_WIDTH]:
;[View Height|VIEW_HEIGHT]:
;[View X|VIEW_X]:
;[View Y|VIEW_Y]:
;[Column #|COLUMN_NUMBER]:
;[Column Name|COLUMN_NAME]:
;[Width|COLUMN_WIDTH]:
;[List of Values|LOV_CODE]:This field will provide the name of the list of values associated with the query being defined. It MUST start with IMPV_ and then the function name that it is for.
At line 22 changed one line
[CLEANUP]
;[Title|LOV_TITLE]:This field provides the title of the LOV. Information purposes only.
At line 24 changed one line
[{If var='loginstatus' contains 'authenticated'
;[DESCRIPTION|DESCRIPTION]:This field holds a brief description of the report list including any details other than the code.
At line 26 changed 3 lines
----
![Discussion|Edit:Internal.IMLQ]
[{InsertPage page='Internal.IMLQ' default='Click to create a new discussion page'}]
;[QUERY TEXT|LOV_QUERY_TEXT]:This field contains the SQL select statement used by the system to determine the values to be reported in the report list.
At line 30 changed one line
}]
----
![Notes|Edit:Internal.IMLQ]
[{InsertPage page='Internal.IMLQ' default='Click to create a new notes page'}]
This page (revision-22) was last changed on 26-Nov-2021 10:22 by jaikenTop