Create a JQL to find issues in a Issue Picker searcher

[Philippe Puy]

Hi,

I have created a custom script field using scriptrunner, type issue picker searcher.

The name of the field is "Initiative link" it is using the following JQL:

project = REAIT AND issuetype = Initiative

Now I need to create a JQL displaying all the issues that have been set in this field.

I tried this:

issuefunction in linkedIssuesOf('project = REAIT', 'Initiative link')

but it is not working, any ideas?

[Ram Kumar Aravindakshan _Adaptavist_ · Accepted solution]

Hi @Philippe Puy

For your requirement, you should use ScriptRunner's JQL Function, i.e. Portfolio.

You should try something like this:-

def issue = Issues.getByKey('MOCK-1')// Issue that has the Issue Picker

def issuePickerValue = issue.getCustomFieldValue('Initiative Picker').toString().replace('[','').replace(']','').trim()

Issues.search("""issueFunction in portfolioChildrenOf("type = Initiative and issuekey = ${issuePickerValue}")""")

Please note that the sample code above is not 100% exact to your environment. Hence, you will need to make the required modifications.

Below is a screenshot for your reference:-

In this example, the Issue Picker value is taken from the issue MOCK-1. The value is the Initiative selected from the Issue Picker.

Once the value from the Issue Picker is extracted, it is placed into the JQL Query.

The result return is the child of the Initiative, i.e. the Epic issue type.

As mentioned above, you will need to modify the code to suite your needs.

Thank you and Kind regards,

Ram

[Carla Ann Rowland · Accepted solution]

try this:

project = REAIT and  issuelinktype ="Initiative link"

Here is a reference link: https://support.atlassian.com/jira-work-management/docs/jql-fields/#Issue-link-type

[Philippe Puy]

Thanks for the insight.