Ctrlk
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Editor Query

Editor Query 'Conditions':

  • Equals (=)

  • Does not Equal (!=)

  • Starts With

  • Ends With

  • Contains

  • IS NULL

  • IS BLANK

  • IS NOT NULL

  • IS NOT BLANK

Editor Query 'Results':

  • Any existing column header in the dataset

  • Constant (selecting this adds a field to enter the constant value)

How to use the Editor Query:

  1. Type CASE WHEN condition1 (using any of the listed conditions).

  2. Type THEN result1 (using any of the listed result formats).

  3. To add more conditions, repeat the pattern WHEN condition2 THEN result2.

  4. To add a fallback without a condition, type ELSE result.

  5. End the statement by typing END.

PreviousCase StatementNextUI Query

Last updated