Versions Compared

Key

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

In general, the pool of issues available for selection is determined by the field’s context.

Further down, it can be narrowed down by additional filtering using a JQL query.

Apart from the default JQL syntax, we provide custom JQL functions to allow even more control of the results.

Issue in relation

This JQL function helps find all your issues within certain relations. It would be best to explain the function's logic using an example.

An employee profile issue has an Advanced Link field ‘Hardware’. It is required to configure selectable issues for this field.

The options available for selection should be displayed only if they are selected in another Advanced Link field ‘Assets'.

The JQL for such scope will appear as follows:

Code Block
issue in relation("issuetype = Hardware", "Assets", "level1")

This expression will return all the issues that are selected in the advanced link fields ‘Organisation - Assets’, both outward and inward. An additional parameter, "issuetype = Hardware" has been added to narrow down the issues by type. "level1" parameter indicates that only issues selected directly in the field will be returned.

Overall, the issue in relation to function has the following structure:

Code Block
issue in relation("JQL filter", "AssetsField name", "Link level")

where the 3 parameters are interpreted as:

"Outward/Inward" (required)- name of the outward or inward advanced link field.

"Link level" (required) - currently extends to levels 1 & 2. When querying for level 2, the query will also return issues linked to issues from level 1.

"JQL filter" (optional) is applied to the issues additionally, e.g. ‘status = Active’.

(info) Currently ‘issues in relation’ does not support the ‘not’ JQL operator.

(warning) This function is applicable only in the Advanced link configuration. It can not be used for JQL search.

JQL Variables

The variables below can be used for data logic configuration for both, Advanced Links and Issue Filter panels.

Status
title{key}
= fetches the issue key of the current issue.

Status
title{projectkey}
= fetches the project key, in which the current issue is stored.

Status
title{assignee}
= fetches the value of an ‘Assignee’ field from the current issue

Status
title{reporter}
= fetches the value of a ‘Reporter’ field from the current issue