This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Maintain Report List Queries#

The Define LOV Queries (IMLQ) form is used to maintain the query selection criteria used to create report lists within Wiki.

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.

---

Notes #

Click to create a new notes page