How to filter only selected fixversions in Jira Structure

[Jayadev]

Hi Team,

 I have few issues for which Fixversion filed is updated with 2 fixversion names (every issue is updated with 2 fixversions)

Issue	Summary	Value of Fix Version/s field
Issue1	Summar1	R100,  LiveR001
Issue2	Summary2	D100, LiveR001
Issue3	Summary3	D200, LiveR002
Issue4	Summar4	D200, LiveR002
Issue4	Summary5	C200, Live002

 Problem:

I am trying to create a Jira structure to generate view grouped by Fixversions and adding a filter to display only fixversions groups that start with Live

 Structure Rules:

Filter items where attribute Fix Version/s contains Live

Group by Fix Version/s        [comment - Group by Issue Field]

Group by Project

Insert issues: project in (ABC)

Output:

Summary

LiveR001          [comment - this is a fixversion level group, beneath it is having all matching ]

R100

D100

C200

LiveR002

However, I am interested to get output with fix version groups that starts with text as Live. Please guide/advise how to achieve this?

 Expected output:

 Summary

LiveR001

LiveR002

 Structure version: Structure for Jira by ALM Worksv8.0.1

Appreciate your help. Thanks in advance.

BR,

Jayadev

[Morgan DUBUISSON · Accepted solution]

Good evening,

Why not filter directly in the JQL?

project in (ABC) and fixVersion ~ "Live*" 

Please let me know if it helps!

Best Regards,

Dubuisson Morgan

[David Niro]

Hello @Jayadev ,

You will want to Group by Attribute and use the formula below.

fixversions.FILTER(LEFT($.name,4)="Live")

What it does is takes the array of Fix Versions and FILTERs out any that do not contain "Live" as the first four characters.

Please let me know if this helps.

Best,
David

[Jayadev]

Hi @David Niro 

Many Thanks. This is great. This solution is working fine if we are building the structure for 1 project.

Apologies that, I had not shared the requirement with completeness earlier.

I have to build structure for more than 1 project (taking 2 projects in this scenario). Details as below.

Project1:

Issue	Summary	Value of Fix Version/s field
Issue1	Summary1	R100,  LiveR001
Issue2	Summary2	D100, LiveR001
Issue3	Summary3	D200, LiveR002

Project2:

Issue	Summary	Value of Fix Version/s field
Issue1	Summary1	R100,  LiveR001
Issue2	Summary2	D100, LiveR001
Issue3	Summary3	D200, LiveR002
Issue4	Summar4	D200, LiveR002
Issue5	Summary5	C200, LiveR002

 Expected output:

 Summary

LiveR001  

          Project1

                                Issue1

                                Issue2

          Project2

                                Issue1

                                Issue2

LiveR002  

        Project1

                                Issue3

        Project2

                                Issue3

                                Issue4

                                Issue5

What I am getting currently:

 Summary

LiveR001  

       Project1

                                Issue1

                                Issue2

LiveR001  

       Project2

                                Issue1

                                Issue2

LiveR002  

       Project1

                                Issue3

LiveR002  

       Project2

                                Issue3

                                Issue4

                                Issue5

The main objective is to do first level grouping at fixversions and next sublevel grouping would be projects.

Appreciate your expert advice here.

BR,

Jayadev.

[David Niro]

Hello @Jayadev ,

No apology necessary!  It looks like there are multiple boards with the same Fix Version names.  

When this happens, even thought the Versions share the name, they are still considered separate, which is why we see the behavior when grouping.  

To work around this, we can convert the Fix Version to Text:

TEXT(
fixversions.FILTER(LEFT($.name,4)="Live")
)

Please let me know if it helps!

Best,
David

[Jayadev]

Many Thanks @David Niro 

This is working.