Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Proper syntax for doing quadruple nested issueFunction JQL statement?

Hi,

Doing project automation in Jira.

My data model looks like this:

            Initiative
|
-------|---------
Epic Epic
| |
---------- -----------
| | | |
Story A Story B Story C Story D

Have an automation use-case that requires traversing from Story A or B, up to Initiative, and then down to Story C or D.

This requires four nested issueFunctionOf statements. My personal record until now was a triple-nested statement. Since the nested queries are used in project automation, and it is the inner JQL statement that controls the query, I do not have the option to use nested filters. 

I searched through the documentation and found examples only of double nested statements using double- and single quotation marks. This forum helped me get three nested levels under my belt using \". 

This is my JQL statement:  

issueFunction in issuesInEpics("issueFunction in linkedIssuesOf('issueFunction in linkedIssuesOf(\"issueFunction in epicsOf(\'key= BEAM_OVP-9852\') \") ') ")

In above example I tried using the following hierarchy:

  • 4th level (outer): "
  • 3rd level: '
  • 2nd level: \"
  • 1st level (inner): \'

But that does not work.

This leaves me with two questions:

  • How many nested levels does Jira actually support?
  • What is the sequence of quotation marks to escape four levels of nested JQL strings?

1 answer

1 accepted

Hi @Jimmy Petersson ,

 

I tried a few, this one doesn't error out among the others:

issueFunction in issuesInEpics('issueFunction in linkedIssuesOf(\'issueFunction in linkedIssuesOf("issueFunction in epicsOf(\\\'key= BEAM_OVP-9852\\\') ") \') ')
  • 4th level (outer): '
  • 3rd level: \'
  • 2nd level: "
  • 1st level (inner): \\\'


Although pretty sure it can be improved a bit but the triple backslashes seem to do the trick 🙂

 

//Radek

Thanks a million, Radek!

Suggest an answer

Log in or Sign up to answer
TAGS

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