Case (if/else)

This common method utilizes if-then-else logic, assigning a result when the corresponding condition evaluates to true, otherwise assigning the final ("else") result –> learn more

CASE
  WHEN @condition THEN @result
  [ ... ]
  [ ELSE @else_result ]
  END

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@condition	(nested) conditions – like those used in a Filter	any Redivis type	true	-
@result	variable or literal	any Redivis type	true	(Variable or value)
@else_result	variable or literal	any Redivis type	true	(Variable or value)