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 3 changed 2 lines
!!!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.
!!!DEFINE LOV QUERIES
The Define LOV Queries (IMLQ) form is used to maintain the query selection criteria used by reports within ePersonality.
At line 6 changed one line
The data is maintained on the [P2K_AM_LOV_QUERIES] and [P2K_AM_LOV_QUERY_COLUMNS] tables.
Define LOV Queries data is maintained on the [P2K_AM_LOV_QUERIES], and [P2K_AM_LOV_QUERY_COLUMNS] tables.
At line 8 changed one line
;[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.
;[List of Values|LOV_CODE]:This field will provide the name of the list of values associated with the query being defined.
At line 10 changed one line
;[Title|LOV_TITLE]:This field provides the title of the LOV. Information purposes only.
;[Title|LOV_TITLE]:This field provides the title of the LOV which will appear at the top of the LOV box.
At line 12 changed one line
;[DESCRIPTION|DESCRIPTION]:This field holds a brief description of the report list including any details other than the code.
;[DESCRIPTION|DESCRIPTION]:This field holds a brief description of the LOV including any details other than the code.
At line 14 changed one line
;[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.
;[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 LOV box.
At line 16 added 13 lines
;[VIEW WIDTH|VIEW_WIDTH]: No Longer used in ePersonality
;[VIEW HEIGHT|VIEW_HEIGHT]: No Longer used in ePersonality
;[VIEW X|VIEW_X]: No Longer used in ePersonality
;[VIEW Y|VIEW_Y]: No Longer used in ePersonality
;[COLUMN|COLUMN_NUMBER]:The sequence number indicates the order in which the columns in the LOV box will appear.
;[COLUMN TITLE|COLUMN_TITLE]: This field indicates the name of the column that will appear in the LOV box.
;[WIDTH|COLUMN_WIDTH]:This field indicates the width of the column in the LOV box.
[CLEANUP]
This page (revision-22) was last changed on 26-Nov-2021 10:22 by jaikenTop