How to get the fixversions with Progress = 100% only?

[Vini]

Hi,

How do I get the issues of Progress = 100%  in the Jira structure?

Thank you!

[LG]

@David Niro  Hi David! I am sorry, I know this is not how things work - but could you please have a look at my question as well? No one seems to know what to do in this case. Thank you!

Display Initiative as a separate column in Roadmap structure 

[David Niro]

Hello @Vini ,

Welcome to the Community!

Could you please share more detail about what your goal is?  Are you trying to add only issues that are completed and then group by Fix Version, are you trying to only show issues that are part of completed sprints?

I look forward to your response.

Best,
David

[Vini]

Hi David, 

Thanks for your quick response. As you can see in the image there is a main folder having grouped by fixversions. However, on the progress column you can see both 100% and less than 100%. 

As folder names completed, I want to list only issues with progress=100% and not less then that.

Hope I have answered your question.

Thank you!

[David Niro]

Hello @Vini ,

You are very welcome.  Thank you for the clarification.  I think I understand now.

As an example EPI22.11-Nov6 is a completed version, but we can see from the Progress column that the version still has at least one issue that was not completed.

Your expectation is that there should only be issues that are “Done” in this version because the version is Completed.

The only way to accomplish this at the moment is to remove the issue from the version.  The progress column is looking at the issues and aggregating their progress at the Group level.  Since the issues under it were not all resolved, technically the Group level is not complete.  If there is a reason that the issue cannot be removed from the Version, could you please share some more details about your use case? 

Please let me know if this helps and feel free to share your idea here.

Best,
David

[Vini]

Hi @David Niro

Is there a way I can include in my query as "progress=100%"

I think I can't call progress column as a jira field in the jql, should it be as - create a custom column and call in jql as "customprogress =100%" ? (Not sure how it works, need your help)

Presently I am using:

Workstream = eCommerce and fixVersion in (Zeppelin_J5B, Zeppelin_J5A, Zeppelin_J2B, Zeppelin_J2A, Zeppelin_J1)

However, among these fixversions, I am looking to display only with progress = 100%

[David Niro]

Hello @Vini ,

There is not a way to reference the progress from a Structure column in JQL.

The only workaround is to remove the issues that have not yet been completed from the completed fix version.

That being said, we may be able to Filter by Formula sometime in the future.  This may present a solution to your use case.  We have a related task in our backlog and I have added your vote.

Best,
David

[Vini]

@David Niro  is there any way I can filter using s JQL? 

[David Niro]

Hello @Vini ,

Those options are not available for Cloud, which means you have an OnPrem hosted instance.  The good news is we can use Transformations to Filter by Attribute. 

You will select Formula from the list.

Your Formula will be:

itemtype != "version" AND
statuscategory != "DONE" AND 
PARENT{item.isreleased}

Operator will be: is not equal to
Value will be: 1
Level can be set to: all levels (since we are ignoring the version in the formula.  If you have multiple levels under the Version, you may need to adjust this to match the level of the issues you want to remove)

Please let me know if this helps.

Best,
David