Available parameters for a PDQ in the IUIE
On this page:
Overview
The exact set of parameters available for a predefined query (PDQ) in the IUIE will depend upon those chosen by the PDQ's publisher. Common PDQ parameters are listed here.
Query options
Metadata | The PDQ form provides several links to metadata (descriptive information).
On the first line of the form, the name of the PDQ is a link to a description of the data returned by the query, as well as general information about the query. Immediately following the PDQ name are the and links. The link displays details on how to control the output returned by the query. The link displays hints and detailed information that will help you use the PDQ effectively.Each PDQ form field name is linked to a description of the form field, which includes such data as the technical name, the datatype of the field, whether it is a column in a database table, and the business use of the field. |
Output destination | Under "Select the Output Destination", you have several choices:
browser screen. is the default setting. Your query will run in the foreground until finished, and then the output will display on theThe The Push a report to another user in the IUIE. option allows you to send the results of your report to another user. This output works the same way as sending to Completed Reports; however, it allows you to send a completed report to additional selected users; seeallows you to enter or select from a drop-down list a four-character Enterprise printer ID to which to send the report output. can be an output destination if the publisher has created the PDQ to perform mailings, and if you have authorization to use mailing functionality; see |
Output format | Under "Select the Output Format", you may specify a particular output type.
The output types available for your PDQ are defined by the information provider at publishing time. A PDQ may have several output options; choose the one that best suits your needs. Two examples of output types are (for displaying output in a browser), and (for loading the output into an alternative viewer). is best suited for quick lookups on small data sets where no further data manipulation is required. Other output type options are better when a large amount of output is expected, or when you expect to modify or manipulate the output.You may need to configure your browser to automatically access Microsoft Excel, Microsoft Word, or other desktop tools as appropriate, when returning formatted data for the first time. |
Wildcards | Fields marked with "Wildcards Allowed" can accept wildcard characters; see Wildcards and logical operators in the IUIE.
|
Buttons
button saves the current PDQ form as a shortcut in My Catalog; see | |
The button executes your PDQ against the database.
|
|
The button displays the possible values for the associated field.
Each valid value is displayed with a checkbox, which, when checked, places it on the PDQ form. If you check multiple values, and the PDQ form field allows multiple values, then a comma-delimited list of values will go to the PDQ form field. Two buttons are located at the end of a "Valid Values" screen:
|
|
Authorized testers, Data Managers, developers, and IUIE Admins can use the button to run the production PDQs against test data located on DSS1TST.
|
This is document aljy in the Knowledge Base.
Last modified on 2021-10-14 11:21:36.