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.