Table of Contents
DEFINE LOV QUERIES#
The Define LOV Queries (IMLQ) form is used to maintain the query selection criteria used by reports within ePersonality.Define LOV Queries data is maintained on the P2K_AM_LOV_QUERIES, and P2K_AM_LOV_QUERY_COLUMNS tables.
- List of Values
- This field will provide the name of the list of values associated with the query being defined.
- Title
- This field provides the title of the LOV which will appear at the top of the LOV box.
- DESCRIPTION
- This field holds a brief description of the LOV including any details other than the code.
- QUERY TEXT
- This field contains the SQL select statement used by the system to determine the values to be reported in the LOV box.
- 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
- The sequence number indicates the order in which the columns in the LOV box will appear.
- COLUMN TITLE
- This field indicates the name of the column that will appear in the LOV box.
- WIDTH
- This field indicates the width of the column in the LOV box.
Notes #
Click to create a new notes pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation