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.
- 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.
