Filter issues based on the FixVersion in an Insight object list

[David Corrigan]

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? 

[Hakan Bahadir]

Hello,

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.

Regards,

Hakan Bahadir

[David Corrigan]

Hi, 

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. 

[Hakan Bahadir]

Hello,

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\")")

Regards,

Hakan Bahadir

[Björn Gullander]

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: 

1. Create a new Readonly Insight field 
2. Configure it by setting:
   1. "Filter scope": "objectType=Suite"
   2. "Filter Assign Scope": VersionAttributeName in (${fixVersions${0}})

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. 

Regards