Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

IQL in JQL statement

Hi, 

I need to query tickets where an object is selected (via custom field), with a specific attribute of an Insight object.

Some context: 

We've set up "Categories" with multiple levels. Those levels are linked to each other by an attribute "Predecessor". The value for the attribute "Predecessor" is the another Insight object (Category) on a higher level.

F.ex level 1 = IT hardware, level 2 = Computer (&predecessor = IT hardware) & level 3 = Processor (& predecessor = Processor)

 A user will fill on his category on the lowest level, but their might be multiple lower levels linked to a higher level. In our query, we want to view all tickets of level 2, including the related tickets of level 3.

TLDR; I want to add an (Insight) attribute as a search parameter in JQL statement.

 

I've tried multiple queries (to retrieve the related tickets of level 2) but no success yet. Queries I tried:

  • "Category" in iqlFunction("Predecessor = 'IT Hardware'")
  • "Category" in iqlFunction("Predecessor.\"Categories\" = \"IT HARDWARE\")
  • "Category" in iqlFunction(object HAVING outboundReferences("Name" = IT Hardware))
  • "Category" in iqlFunction("Predecessor" IN ("ICT-84484"))

 

Example of a category in Insight: 

Schermafbeelding 2021-06-18 154843.jpg

2 answers

2 accepted

0 votes
Answer accepted

Already got a solution myself (for those who encounter the same issue): 

"Category" in iqlFunction("Object HAVING outboundReferences(Key = \"OBJECTKEYOFHIGHERLEVEL\")")

 

This works, but a method via the attribute of an object would be more scalable, so other solutions are still welcome!

0 votes
Answer accepted

Try

Category in iqlFunction('Name = "IT Hardware" OR Predecessor = "IT Hardware"')

or

Category in iqlFunction("Name = \"IT Hardware\" OR Predecessor = \"IT Hardware\"")

From a quote/escaping point of view:

  • The outer quotes are interpreted by JQL. JQL accepts both single or double quotes for function parameters
  • The inner quotes are interpreted by insight IQL and only double quotes are allowed. So if you used double quotes for the outer quotes, then you must escape the inner quotes.

AS for the IQL logic, the first part (Name = "IT Hardware") will get you all the issues linked directly to your level 2. And the second part of the OR will get you all the issues in the Third level if the Predecessor (second level) is a match.

Thank you Peter for the clear explanation. This worked. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira Service Management

Atlympic Event: Jira Service Managemnt

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

87 views 0 1
Read article

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