I need to query tickets where an object is selected (via custom field), with a specific attribute of an Insight object.
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:
Example of a category in Insight:
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!
Category in iqlFunction('Name = "IT Hardware" OR Predecessor = "IT Hardware"')
Category in iqlFunction("Name = \"IT Hardware\" OR Predecessor = \"IT Hardware\"")
From a quote/escaping point of view:
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.
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! ...
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