Accepted Solutions (1)

Accepted Solutions (1)

DimaKudryavtsev

06-08-2019

Hi

There is no good manual for this function, but it is very basic and intuitive.

It looks like Iif(<expression>,<if expression truly, do this>,<otherways do that>)

Expressions can be any valid XTK expression, for example:

Iif(@myValue=1 and [nested/@value] >=2, "YES". "NO")

The following comparison operators are supported:

=, >, <, >=, <=, !=, IN, LIKE, NOT, IS NULL

Actions also can be anything, even another Iif() function. Ultimately, Iif will be converted to SQL expression CASE WHEN ... THEN ... ELSE ... END

p.s here are some resources:

Defining filter conditions

Advanced expression editing