List of model objects

The list of model objects depends on what expression you are building. For example, for the record’s derived fields you have:

  • Other fields of the record

  • SQL functions

  • Variables

  • Constants

  • If-then-else

  • Parameters (including FromDate and ToDate)

  • The WHERE_IN and WHERE_NOT_IN operands to add or exclude several data objects where the condition can occur

Also, some special entries exist, such as Value of Type, which is a mechanism for the user to enter the typed value. Under this node there are two options: String and DateTime.

You can add "value of type" either by direct entry (as described above) or using the corresponding item from the tree. For example, once you select an entry such as String, it is displayed as follows:



As you type the direct entry for value, it is shown in the expanded state:



As soon as the token loses selection, it is shown in the collapsed state.