Parameters available for an IUIE data extract
On this page:
Overview
In the IUIE, you may manipulate a number of parameters in order to run a precise data extract. Below are tables describing these options.
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 check individual columns to return. |
Include column names | Under "Include Column Names?", choose (default) or to specify whether the names of the selected columns appear in the first row of the output. |
Maximum number of rows to return |
You may specify a maximum number of rows to return in order to restrict the number of rows read from the database. This is useful for testing and debugging queries that might normally return a large number of rows. The precise meaning of the phrase "maximum number of rows to return" is as follows: read rows from the table that satisfy the SQL WHERE clause, assigning sequential row numbers until the "Maximum Number of Rows to Return" value has been met. |
Return distinct rows only | When is checked, no duplicate rows are included in the output.
For example, to find the names of the organization managers for a particular campus, you would need to use the account/organization data group under the Financial Data Groups section. This table contains the information you need, but it is repeated for each account in every organization. Since you need only information about the organizations, select the appropriate columns (organization name, organization code, organization manager) and check . Then, each organization will appear only once. |
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 alternate 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, often called data extract parameters, 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:
|
Include SQL query text | If you check , the SQL query built from the parameter values you supply will be listed on your output. |
Retain Leading Zeros of Character Columns |
Check this option to retain leading zeroes when outputting to the XSL format. This is especially useful when dealing with University IDs. |
Buttons
Executes your query against the database |
|
Displays the screen without the "Additional Criteria", "Record Delimiter", and "Field Delimiter" selection fields |
|
Displays three additional query options not present on the "Novice" screen:
|
|
Displays a screen of values valid for the current field |
|
Saves a data extract or template form as a shortcut in My Catalog; see About shortcuts in the IUIE. |
|
Erases changes on the current screen |
|
Provides additional options if you have been authorized to use mailing functionality; see Use mailing functions in a data extract in the IUIE. |
|
Allows authorized testers, Data Managers, developers, and IUIE Admins to use the button to run the production version of the datagroup against test data located on DSS1TST |
This is document aljt in the Knowledge Base.
Last modified on 2021-10-15 15:10:03.