Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Filter label options

Write like this:

Code Block
{labelfield}.Matches(0)  // First label value option selected

{labelfield}.Matches(2)  // Third label value option selected
{labelfield}.Matches("1,2,3")  // Any of options 1, 2 or 3 selected

You can also use the optional operator:

Code Block
{labelfield}.Matches(2, "=")  // Third label value option selected
{labelfield}.Matches("1,2,3", "=")  // Any of options 1, 2 or 3 selected

If a label is not shown by default, it can also have the "null" option:

Code Block
{cffield}.Matches(null)  // No label set
Exclude label options

Write like this:

Code Block
{cffield}.Matches("3|,4|,5", "!=")  // None of the options must appear

If a label is not shown by default, it can also have the "null" option:

Code Block
{cffield}.Matches("null|, 0", "!=")  // No label or just default label
Any label option

To filter for data where the label has any of the options:

Code Block
{cffield}.Matches(null, "!=")  // Any label
Comments

When specifying a single value, the quotes are optional.

Code Block
{cffield}.Matches("3", "=")
or
{cffield}.Matches(3, "=")

 

Query tree

When running queries the results may include a JSON representation of your query.

...