Multi Cascade JQL function

Formal JQL syntax

Below you can see an example of the JQL query, which includes Multi Level Cascade Field's properties.

• The multi cascade name is one of the names of the Multi Level Cascade custom fields as configured on your JIRA

• The search criteria is key-value pairs where key is a level's name and value is an option's label. 

  • Value part might contain multiple arguments separated by comma - it means that the search will be similar to the 'OR' operator:

    issue in multiCascade("Countries","country=Belgium, Ukraine")

    searches by 'Belgium' or 'Ukraine'.

  • Different pairs might have the same keys (levels). The search mechanism will combine these pairs and work similar to the 'OR' operator:

    issue in multiCascade("Marvel","superhero=Iron Man", "superhero=Captain America")

    searches by 'Iron Man' or 'Captain America'.

  • Amount of pairs also matters. The search mechanism searches an exact value by given criteria (if there is no wildcard used), consequently if the criteria consists of 2 unique levels - it will search only for Multi Cascades with 2 levels, neither less nor more:

    issue in multiCascade("Departments","country=Austin", "department=R&D")

    mathes only with value 'Austin - R&D'.

  • Search with a Wildcard - Multi Level Cascade Field supports wildcard search. Add "*" like and argument of your criteria:

    searches by 'Belgium' as a country and any other values in other levels.

  • Case insensitive values. Pairs in criteria and Multi Cascade field's name are fully case insensitive