Specifying filter queries
The filter string is an expression used to specify searches for non-key fields.
On the Properties tab of Landmark Transaction Builder, specify the filter string. Use this format:
Landmark_field_name operator value
Use this table to specify the variables in the filter string expression:
| Variable | Description |
|---|---|
| Landmark_field_name | Specify a name of a valid Landmark field. The field is based on the Landmark object on which you are performing the query or transaction. |
| operator |
Specify one of these operators:
|
| value | Specify the value to be searched. |
If the type of the Landmark field is numeric, specify the expression using the given format. For example:
age > 10
If the type of the Landmark field is string, specify the value enclosed in quotation marks (""). For example:
Description = "this is a string"
Any special character such as a backslash (\) or an ampersand (&) within the value string must be preceded by a backslash. The quotation marks enclosing value must each be preceded by a backslash. Specify the entire filter string or the _filterString value enclosed in quotation marks. Use this format:
"Landmark_field_name operator \"value\""
These are examples of query strings that include special characters:
-
"Description = \"this is a \"query\" string\"" -
"Description = \"Bed \& Breakfast\"" -
"Description=\"Special characters such as \& and \\ must be preceded by a backslash\.\""
The filter string can contain a compound expression. Use "and" or "or" (must be all lowercase) to separate expressions. Use parentheses (()) for grouping expressions. For example:
"Amt=5 or (Amt=8 and Description=\"Bed \& Breakfast\")"
To search using a wildcard in Landmark Transaction Builder, specify a filter string for the field using the like operator followed by a wildcard character in the filter field on the second tab of the Transaction Builder. For example: _filterString = PfiTask.TaskName like "*Task"
You can create a filter query on the General tab of the Landmark Transaction "start" node. In the Landmark transaction string, specify the script that includes the filter string expression as the value for _filterString. These are examples of filter strings specified within a script:
-
... & _filterString=age>10 & ... -
... & _filterString=Description="this is a string" & ... -
... & _filterString="Description=\"this is a \"query\" string\"" & ... -
... & _filterString="Description=\"Bed \& Breakfast\"" & ... -
... & _filterString="Description=\"Special characters such as \& and \ must be preceded by a backslash\.\"" & ... -
... & _filterString="Amt=5 or (Amt=8 and Description=\"Bed \& Breakfast\")" & ...