Versions Compared

Key

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

...

Code Block
{cffield}.Matches("o1|o2|o3", "anyof")
== translated to ==>
{cffield}.Contains("|o1|") OR {cffield}.Contains("|o2|") OR {cffield}.Contains("|o3|")

 

Labels count field

The labels count field returns the total labels assigned to an object such as a job or project.

It contains 2 properties:

  • cnt: Total assigned labels.
  • xp: Total explicitly set labels. This excludes labels that are configured to automatically show up on ALL objects with a default value.

 

The available query options are:

Filter for xp > 0

This filter returns all objects that have at least one label that was explicitly assigned by a user.

Code Block
{field}.Matches(true)  // Value xp must be greater than 0
Find for xp = 0

This filter returns all objects with no label assigned by a user.

Code Block
{field}.Matches(false)  // Value xp must be 0

 

 

Label field

The available query options are:

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

 

Query tree

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

...