Skip to Main Content
Return to Navigation

Query

This is the action associated with the Query step type.

Exec

Description

Runs a public query in PeopleSoft Query and downloads the results. To run a private query, use the Exec_Private action.

Note: Context sensitive help is available by double-clicking in the Value column to display and enter the query parameters.

Parameters

outFile=value;

The query output file.

outFolder=value ;

The folder where the result will be saved. If this parameter is missing, the system will use the value in the local option.

outFormat=value;

The file format that will be used to download the result file. If this parameter is missing, the system will use the value in the local option.

param=value;

The list of comma delimited values for all the query parameters.

0rows=value;

If the query returns zero rows, add a log entry of type value. Valid values are Pass, Fail, or Warning.

Nrows=value;

If the query returns one or more rows, add a log entry of type value. Valid values are Pass, Fail, or Warning.

Exec_Private

Description

Runs a private query in PeopleSoft Query and downloads the results.

Parameters

outFile=value;

The query output file.

outFolder=value ;

The folder where the result will be saved. If this parameter is missing, the system will use the value in the local option.

outFormat=value;

The file format that will be used to download the result file. If this parameter is missing, the system will use the value in the local option.

param=value;

The list of comma delimited values for all the query parameters.

0rows=value;

If the query returns zero rows, add a log entry of type value. Valid values are Pass, Fail, or Warning.

Nrows=value;

If the query returns one or more rows, add a log entry of type value. Valid values are Pass, Fail, or Warning.

Note: Query steps do not support simultaneous usage of both 0rows= and Nrows= parameters in the same step.

Use the following formats to specify query parameters:

Page Control

Format

Text

param=value

Radio button

param={RB}value

Combo box

param={CB}value

Check box

param={CH}value

Text box

param={EB}value

Example

This example shows the Query.Exec step type, with the dialog box for the values open. In this example, the query has 3 prompts: a text field, a date field and a check box. The query is expected to return rows.

Image: Example of Query.Exec Action

This example illustrates entering the value parameters for the Query.Exec action.

Example of Query.Exec action