UI Query
The Filter 'UI query' simplifies the Filter 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:
After entering the dataset view, click transform, and below the quick links, you will see a filter button. Click it
Choose the UI Query bubble, and pick the field for filtering
Click the pencil icon to add a 'condition and result', if needed, hit the plus to add more 'conditions and results' to the field
When done, hit 'OK'
You can hit the plus next to the field name to add another field for filtering
Once you have completed your filter conditions hit 'OK' again to apply to the dataset
Last updated