Show TOC

Background documentationSQL Query Parameters

 

If you select the Use Typed Parameters checkbox in the Parameters SQL query template category, the Parameter Type column appears in the Parameters Table. Using the Parameter Type dropdown, you can select the data type for the parameter. The system checks the parameter value against the selected data type for that parameter.

The following table lists parameters that are specific to SQL queries.

See also:

Query Parameters

SQL Query

Parameter

Data Type

Description

Tables

String list

Database tables or views used in the query.

Applies to Query mode.

Columns

String list

Database columns used in the query. The columns can include the following:

  • Table qualifiers

  • Aggregate functions

  • Column aliases

JoinExpr

String

SQL WHERE clause.

For example, (Lot.ID = QC.ID) AND (QC.State = 'Released').

SortExpr

String list

SQL ORDER BY expression.

For example, Lot.ID ASC,TotalQty DESC.

GroupingExpr

String list

SQL GROUP BY expression.

For example, Lot.MaterialCode,QC.State.

DateColumn

String

Database column used to construct a WHERE clause for date-sensitive queries.

Query

String

SQL statement to be run.

QueryParams

String list

Parameters appended to the Query parameter used to run stored procedures.