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:

1. Choose the WHEN condition, 'Column Header name' and the condition

2. For the result, select the THEN condition, 'Column Header name' or a 'constant'

3. 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