You are here:
Parameters
Parameters are modeled and can be used in the JOIN and QUERY conditions to filter the result set.
Required Editions
| Available in: Enterprise, Performance, and Unlimited Editions |
A parameter replaces the corresponding query condition macro during run time. The name attribute in the parameter replaces the corresponding macro in the query condition. For example, the name of a pKey attribute.
<Parameters>
<Parameter name="callPKey"/>
<Parameter name="customerPKey" type="TEXT"/>
</Parameters>
| Attribute | Description | Type | Required |
|---|---|---|---|
name
|
Name of the attribute. | literal | Yes |
baseType
|
Specifies date, time, or DateTime. | literal | No |
type
|
SQLite type (NULL, INTEGER, REAL, TEXT, LIST). LIST is used for parameters used in "IN" conditions. All items of the list, array or comma separated list in a string, must be the same type (string or numeric). | literal | No |
treatAs
|
Set to sqlSnippet to include the parameter directly into the statement. | literal | No |
Did this article solve your issue?
Let us know so we can improve!

