We have a "Suite" object in Insight, which groups together releases that have been pushed to customers for multiple pieces of software.
What we need is to specify suite "ABC", get the releases linked to it, and the Issues linked to those releases.
How do I query the attribute of a Suite from iqlFunction to compare it to an Issue FixVersion?
Assuming that you have the following configured in Jira and Insight:
- An Object Type called Releases
- An Object Type called Suite
- A referenced attribute in Suite for keeping Releases
- A Suite object called ABC with several releases defined
- A Jira custom field called FixVersion where you can select Releases
Then following would give you the list of Issues for ABC suite:
FixVersion in iqlFunction("objecttype = \"Releases\" AND object having inR(objecttype=\"Suite\" and Name = \"ABC\")")
I hope this helps.
Almost, but our Suite has an attribute where the type is the Jira Version (named "Application Version"). A Suite contains a list of multiple Versions, and we want the list of Issues associated with our "Suite" via the fixVersion on the issue.
The iqlFunction seems to return the Insight Object, but I need the list of Versions linked to that object.
The results of an iqlFunction is a list of Objects always. You can configure one of the following:
1) A simple solution would be to add a new Insight Custom Field for keeping the Suite information in the Issue. You can auto-fill this Custom Field with Insight Post Functions when a fixVersion is set for the Issue. Assign object/s based on an IQL query based on data from an issue would help you. Then JQL filter for finding the Issues would be as:
Suite = "ABC (XXX)"
2) Another way could be keeping the Jira configuration in Insight. You can install Insight Jira & Bitbucket Integration application which will pull Jira configuration into Insight periodically. Then you will have Versions as Objects, and you can create referenced attribute in your Suite to the Versions. (i.e. Attribute Name can be "Application Version", attribute type can be Object and the reference can be Version object type). For finding the issues you can use:
fixVersion in iqlFunction("objecttype = \"Version\" AND object having inR(objecttype=\"Suite\" and Name = \"ABC\")")
Agree with Hakan that creating a separate Insight custom field for Suite is the way forward. To make the solution even more robust you can use the "Filter assign Scope" functionality in the custom field. Do like this:
Now the Suite field will automatically be updated as soon as an issue is updated.
It will now be easy to make reports and searches on the Suite field.
Note that you'll need to bulk edit existing issues as the Suite field will only be filled in when updating the issues.
This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity. Atlassian:...
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