Table of Contents
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.The 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. It MUST start with IMPV_ and then the function name that it is for.
- Title
- This field provides the title of the LOV. Information purposes only.
- DESCRIPTION
- This field holds a brief description of the report list 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 report list.