Define conditions

Please note the following about the definition of WHERE conditions in native SQL in the context of Alfabet configurations:

• It is recommended to use the prefix N in WHERE conditions performing a string comparison. The N prefix ensures that the string is not converted into the character set as specified through the collation of the database. This is of special relevance for databases with a collation defining a character set not corresponding to Latin-1.

  For example

  • WHERE APPLICATION.STEREOTYPE=N'Technical Application'
• When defining conditions for boolean properties, take into account that properties of the data type boolean can have three values:
  • 0 = the value is set to false
  • 1 = the value is set to true
  • Null = the value is not set

  For boolean properties that are not configured to be mandatory, WHERE conditions must be formulated to take all three settings into account.

• Alfabet parameters can be used in WHERE conditions to base a comparison on a return value from a filter field or from the current environment, for example the object the user is currently working with. Documentation of parameters is provided in a separate section.