Available parameters for an indexed report in the IUIE
Overview
In the IUIE, you can manipulate a number of parameters to run a precise indexed report. Below are tables describing the various query options and buttons.
Note:
The exact parameters available will depend upon the indexed report selected.
Query options
Columns to be included | Under "Select Columns to Be Included", you may choose which columns should appear in the output. Selecting returns all columns. Selecting allows you to select individual columns to return by placing a checkmark beside them.
|
Include column names | Under "Include Column Names?", choose
or , depending upon whether you want the names of the selected columns to appear in the first row of the output. (The default selection is .)
|
Output destination | Under "Select an Output Destination", you may choose where the query output will go:
|
Output format | Under "Select the Output Format", you may choose between multiple formats. (for displaying output in a browser) and (for loading the output into an alternative viewer, such as Excel) are common choices.
is best suited for quick lookups on small data sets where no further data manipulation will be required. returns data in a format readable by Microsoft Excel. This option is best when you expect a large amount of output, or you expect to modify or manipulate it. You may need to configure your browser to automatically access Microsoft Excel when returning spreadsheet-formatted data for the first time. |
Selection criteria | Selection criteria are often called data extract parameters, and are the heart of your search. The values supplied are incorporated into the
WHERE clause of the generated SQL SELECT statement, thus restricting the rows returned by the query.
A sample parameter line contains the following elements:
|
Buttons
executes your query against the database.
|
|
The button displays the screen without the "Additional Criteria", "Record Delimiter", and "Field Delimiter" selection fields.
|
|
The button, if allowed by the publisher, displays three additional query options not present on the "Basic" screen:
|
|
The button displays a screen of values valid for the current field.
|
|
button saves an indexed report as a shortcut in My Catalog. For more information on the button, see | |
The button erases changes on the current screen.
|
This is document alpv in the Knowledge Base.
Last modified on 2021-09-20 15:09:08.