You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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:
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.
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!