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:
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:
|
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. |