It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Searching "Parent Link" fields Edited

I am trying to construct JQL to find all tickets with Parent Links from a specific project. Using ScriptRunner, I see the components of the "Parent Link" field are: 

  "customfield_10018": {
    "hasEpicLinkFieldDependency": false,
    "showField": true,
    "data": {
      "id": 15713,
      "key": "DSJW-293",
      "keyNum": 293,
      "summary": "Stability",
      "projectId": 10011,
      "issueType": {
        "id": "10023",
        "iconUrl": "/secure/viewavatar?size=medium&avatarId=10322&avatarType=issuetype"


Thus the "key" is the field I need to filter upon, but I cannot figure out a way to create JQL to do a sub-string match. Something on the order of: 

"Parent Link" ~ "DSJW"

but I receive an error that "~" is not supported by the field. Nor am I able to drill down the hierarchy of fields to get to the "key" - I get the error "Field '' does not exist or you do not have permission to view it."

Is this possible? I am using Jira Cloud. 

1 answer

Hi Janene,

Thank you for your question.

I can confirm that ScriptRunner for Jira Cloud does not provide the same portfolioChildrenOf() and portfolioParentOf() JQL functions that the server version provides in order out of the box in order to search for Portfolio issues as the API to provide this function does not exist in the Jira Cloud as it does in Jira Server.

The only functionality that ScriptRunner for Jira Cloud provides to search for links is the linkedIssuesOfRecursive() JQL function which the plugin provides and is documented here.

This function can search for Issue links but will not be able to traverse the hierarchy provided by Jira Portfolio as this is currently not supported by Jira Cloud.

You can see more detailed information on the differences between the cloud and server versions inside of our documentation page located here.

I have also looked at what JQL Operators that the Parent Link field supports inside of the Atlassian documentation page here and can confirm that the Parent Link field does not support the ~ operator.

This means you can not search for a value contained in the field and that Jira Cloud will only allow you to search on the field using the operators specified in the documentation page linked above which contains examples on how to search the Parent Link field.

If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.



Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you