Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

In the IUIE, in an indexed report, what parameters are available?

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 All Columns returns all columns. Selecting Selected Columns: allows you to select individual columns to return by placing a checkmark beside them.
Include column names Under "Include Column Names?", choose Yes or No, depending upon whether you want the names of the selected columns to appear in the first row of the output. (The default selection is Yes.)
Output destination Under "Select an Output Destination", you may choose where the query output will go:
  • Wait for Output is the default radio button. Your query will run in the foreground until finished, and the output will go to your browser screen.

  • Send Output to Completed Reports Folder allows a query to execute in the background, which allows you to continue working within the IUIE without waiting for a query to finish. The report output goes to the Completed Reports folder.

  • Send Output to Printer allows you to specify a four-character Enterprise printer ID to which to send report output.
Output format Under "Select the Output Format", you may choose between multiple formats. Web Browser (for displaying output in a browser) and Spreadsheet (for loading the output into an alternative viewer, such as Excel) are common choices.

Web Browser is best suited for quick lookups on small data sets where no further data manipulation will be required. Spreadsheet 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:

  • A Column Description link displays metadata about the column, including the datatype, size, and what datagroups contain it.

  • A "Column Value" field allows you to enter one or more values, separated by commas.

  • A Valid Values button, if present, allows selection of values for the column.

  • A Wildcards Allowed link, if present, denotes that wildcards are allowed in the "Column Values" field and makes available documentation about the use of wildcards; see In the IUIE, what wildcards and logical operators can I use?

Buttons

Run Run executes your query against the database.
Basic The Basic button displays the screen without the "Additional Criteria", "Record Delimiter", and "Field Delimiter" selection fields.
Advanced The Advanced button, if allowed by the publisher, displays three additional query options not present on the "Basic" screen:
  • "Additional Criteria": You can add additional clauses to this text area to further refine your output.

  • "Field Delimiter": This option allows you to specify the character(s) placed between fields in a query result. This delimiter should be a character or characters not contained within any field values. The default field delimiter is a Tab ("Tab" selection). Other recommended values are the tilde ( ~ ) and the comma ( , ). For Microsoft Excel, a Tab is recommended.

  • "Record Delimiter": This option allows specification of the character(s) placed between records in a query result. This delimiter should be a character or characters not contained within any record values. The default record delimiter is a newline ("Newline" selection), and this is recommended for Microsoft Excel. Another recommended value is Carriage Return + Line Feed (CR/LF). Other selections are rarely used except in special situations.
Valid Values The Valid Values button displays a screen of values valid for the current field.
Save Settings The Save Settings button saves an indexed report as a shortcut in My Catalog. For more information on the Save Settings button, see In the IUIE, how can I save my settings as a shortcut in My Catalog?
Reset Query The Reset Query button erases changes on the current screen.
This is document alpv in domain all.
Last modified on February 09, 2009.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.