Filtering by Catalog Values

You have the following possibilities when specifying variable catalog values as <filtervalue>:

• Search for code: #<catalog code>

  Example: select from (FI) where (Country=' #29 ')

  For hierarchical catalogs a valid filter value consists of the child and the parent code, separated by "~": #<child>~#<parent>

  Example: select from (AR) where (Product='#3~#1' OR Product='#3~#4')

• Search for (part of) the catalog text: <text>

  <text> may contain wildcards (*).

  Note: Note: You can use literal character values of ‘*‘ and ‘?’ using the escape sequences ‘\*’ and ‘\?’.

  Examples:

  Country=' Deutschland '

  Country=' *land '

• Search for (part of) a description: #desc:<search string>

  <search string> may contain wildcards (*).

  Example: select from (FI) where (Country=' #desc:my* ')

• Search for external key: #xk*:<external key>

  <external key> may contain wildcards (*).

  Examples:

  Country=' #xk:100* ' searches for records with an external key starting with "100"

  Country=' #xk*:100_2_28 ' searches for exactly this external key.

• For description and external key you can specify the language to be searched:

  Country=' #desc,2:my*' searches for description "my*" only in language no. 2.

  Country=' #xk,1*:100_2_28 '

  Note: Note: Only the specified language is searched, i.e. no parent languages are searched.
  Note: Note: You cannot use an external key filter inside a hierarchical catalog filter.

Notes on filtering by fixed catalog values:

• Search by code or text:

  select from (FI) where (LeadStatus='#1')

  or

  select from (FI) where (LeadStatus='Interest')

• Specifying no value (e.g. select from (FI) where (LeadStatus='')) results in the value with code '0' ("Cold" in this example).