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

Filter issues based on the FixVersion in an Insight object list

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? 

1 answer

0 votes

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

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. 

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

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

Like Hakan Bahadir likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

345 views 3 14
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