UI Query
The case statement 'UI query' simplifies the case statement Query from a manual text box input, to a drop down selection box format.
UI Query 'Conditions':
-Equals (=)
-Does not Equal (!=)
-Starts With
-Ends With
-Contains
-Is Null
-Is Blank
-Is Not Null
-Is Not Blank
UI Query 'Results':
-Any existing column header in the dataset
-Constant (this will add another drop down box to put the constant in)
How to use the UI Query:
Choose the WHEN condition, 'Column Header name' and the condition
For the result, select the THEN condition, 'Column Header name' or a 'constant'
If you need to add more conditions, hit the plus and select the 'Else' (Else only gives you a result option) or 'Else if' to repeat the first two steps
Last updated