This guide provides detailed instructions on how to effectively use JQL queries to apply filters using Multi-Level Cascading Select.
| Infotip |
|---|
In Cloud instances, Multi-Level Cascading Select is optimized for JQL filtering. We strongly suggest searching for issues using advanced JQL search instead of basic search. |
How to refer to MLCS fields in a JQL query
There are two ways to refer to MLCS fields in a JQL query:
By field name:
Use the name of a MLCS field to refer to that specific custom field. For this search, a JSON-like value is required.
...
By issue property:
issue.property[“com.sourcesense.mlcs”].lv(n) and it’s alias, mlcs_lv(n). They both work similarly. The latter is an alias that we created to make it easier to write the property. Change the (n) with the lv number to match the level of the option you are looking for.
| Info |
|---|
|
Find the level and names of your options
In this section, we show how the MLCS integration in JQL queries can be exploited to search for issues, even without admin privileges (therefore with no access to the MLCS field configuration).
| Info |
|---|
To assist you in writing the JSON-like value, enter the name of the MLCS field along with a valid operator to retrieve all unique selection sets from your issues for that specific field.  |
If you do not have admin access to the custom field page and we do not know the configuration tree, we can use the suggestions from the autocomplete mask activated by typing the operator after the name of the field. This will retrieve all the occurrences of that field and the relative selections.
...
Once the suggestion is chosen, a JSON-like value populates the JQL query, indicating the filter applied. Now, we have access to the option names (label) and the relative IDs (value).
...
Using MLCS Options in JQL Queries
There are a number of ways to search for issues using MLCS issue property. Below, you'll find a series of use cases demonstrating how to perform JQL searches effectively.
Search for issues where the option appears in any MLCS field.
You can specify the option name (label) and its level to filter issues on any MLCS field that contains that selection. This is the syntax: mlcs_lv(n) = <option-label>.
Use case scenario
The goal is to select the issues that contain the option “1.1”. Multiple MLCS custom fields share this same option, and we need to retrieve all of them.
In this use case, we do not specify the custom field ID, so the syntax will be: mlcs_lv1 = "1.1".
...
Issues with different MLCS custom fields appear in the results, all with the same option selected (1.1). Note that even if lower levels of options are selected, as long as the 1.1 option is present, the issue is shown (1, 1.1, 1.1.1).
Search for issues where the option appears in a specific MLCS field.
If you are looking for a selection in a particular field, you can narrow your search by adding the field ID:
mlcs_lv(n) = "<cf ID>:<option label>" .
Use case scenario
The goal is to find issues where option 1.1 is selected, but this time, we need to retrieve only those where the option appears specifically in the mlcs-cloud-example-1 field. In this use case, we need to know the mlcs-cloud-example-1’s custom field ID, here is how you can retrieve it. the syntax will be: mlcs_lv1 = "10049:1.1" .
...
| Child pages (Children Display) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...
Limitations
lowest level searchable
...