Cisco Cisco Process Orchestrator 2.X User Guide
D-24
Cisco Tidal Enterprise Orchestrator Reference Guide
OL-24928-01
Appendix D Using Table Activities
Defining the Select from Table Activity
WHERE Clause Example
The WHERE clause specifies join and filter conditions that determine the rows that the query returns.
Source:
Description
If the ColumnName, in an expression, for one column is "UnitPrice", and another "Quantity",
the expression containing a WHERE clause would be as follows:
"UnitPrice * Quantity < 1000"
If a column name satisfies a condition operator, it must be wrapped in either square
brackets or the "`" (grave accent) quotes. For example, to use a column named "Column#"
in an expression, use one of the following:
Total * [Column#]
or "`Column#`":
Total * `Column#`
If the column name is enclosed in square brackets then any ']' and '\' characters (but not any
other characters) in it must be escaped by prepending them with the backslash ("\") character.
If the column name is enclosed in grave accent characters then it must not contain any grave
accent characters in it. For example, a column named "Column[]\" would be written:
other characters) in it must be escaped by prepending them with the backslash ("\") character.
If the column name is enclosed in grave accent characters then it must not contain any grave
accent characters in it. For example, a column named "Column[]\" would be written:
Total * [Column[\]\\]
or
Total * `Column[]\`