I need to find all the feature issue types which are not Done but all the issues in feature are done

[Yatiraj Sharma]

Hi There,

Need some help, I want to find out all the Features in a project (custom issue type and hierarchy, Portfolio Epic --> Feature -- Story) which have all the issues in these features Status and Done but Feature itself have not been marked As Done.

I tried issueinEpic but does not work well. 

[Muhammad Moazzam Hassan]

There is no such JQL that can retrieve this result.

But, it is possible via automation rule.

Create Schedule Rule: Write Query: issuetype = Feature and status != Done.

Then add a condition: Related issue condition if Children All Match the Specified JQL present then print the issuekey of the feature. 

Then copy all issuekey and you can use in JQL like "issuekey in ("Copy all the issue keys").

[Danut M _StonikByte_]

Hi @Yatiraj Sharma,

I'm afraid that it is not possible to have this at the JQL level.

A possible option would be to search for an app / plugin on Atlassian Marketplace.

If you are considering using an app, our Great Gadgets app can be helpful. It offers a Work Breakdown Structure (WBS) gadget that can easily display the issues from a filter by their structure Portfolio Epic --> Feature --> Story --> Sub-task along with their status. 

All you have to do is to configure the gadget with a filter or JQL that return the features, epics and stories.

This will give you a quick overview about the work-items and will help you identify the parent issues that are not done. 

Danut