How do I find user stories without any critical or major defect?

[Shubham Adhikari]

Hello folks,

Let's say I have 20 user stories with bunch of defects on each. I am trying to list out the user stories which does not have any major or critical defects associated with it. How would I go about it? Sorry, I am a new user and not sure if I have enough information in my question. 

[Lucas Modzelewski _Lumo_]

It depends how you are linking those user stories with defects e.g links, subtask or with some 3rd party apps (like Xray) it might be easy to spot if the status on story is green, if every test passed. Those 3rd pary apps probably have documentation how to overview status of tests.

If you try to search for defects related to user story with JQL, you might end up with queries returning nothing, because the result of query are issues, so if nothing matches the search, nothing will be returned.

I'm from the team behind 2 apps which might help a bit:

- Issue Links Viewer - this app display links, also on JQL search, with this you could visually check which issues have the most issues linked

- Excel 365 Connector - this app allow to import/export Jira issues to Excel, this way you can use Excel features to search, filter, count data etc. 

[Shubham Adhikari]

I am not trying to search for defects but rather user stories that do not contain major or critical defects. Unfortunately, I would not be able to use 3rd party apps due to organization's restrictions.

[Lucas Modzelewski _Lumo_]

You can try with gadgets on dashboard, eg. the filter count might work, it would require creating filters but might give a nice overview. 

I found some awesome example: https://community.atlassian.com/t5/Jira-questions/How-to-use-Filter-Count-Gadget-to-display-number-of-tickets-per/qaq-p/2270068