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\")"

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\")" & ...