How to write a query for all stories attached to a specified Feature.

[Christine Darczyn]

I keep finding out of date answers for my question.  I need to write a query that will tell me all the stories attached to specific features (so that I can easily bulk tag them to a fix version).

Is there an Atlassian training that will give me a crash course in query writing and how to better pull what I am looking for?

[Trudy Claspill]

Hello @Christine Darczyn 

Welcome to the Atlassian community.

What are "features" in your instance? Is that an issue type?

How are your stories "attached" to your "features"? Are you using generic issue linking to connect them directly? Are the stories child issues under the "feature"? Is "feature" an issue type that is above Epics, such that features have Epics as children and Epics have stories as children?

Those questions need answers before we can provide meaningful advice on how to write a query that meets your needs.

With regard to training, the Atlassian University has free training on many topics, include creating searches with JQL.

https://university.atlassian.com/student/catalog/list?search=jql

[Christine Darczyn]

We do not yet utilize Epics.  We have issues (stories) and they are connected to the next level: Feature Links.  If I am viewing a story/issue, I can see the feature it is attached to.  When you look at the feature, it has many stories/issues attached as bodies of work.  Does that help?  

So the heirarchy that we follow, via SAFe, is smallest to biggest:  Task, Story, Feature, Epic.

I want to see the x# of stories that are all attached to one feature (the parent, if you will).

[Trudy Claspill]

Hello @Christine Darczyn 

That helps some, but does not truly show us the connectivity.

Can you show us a Feature including in the display the list of stories attached to it, so that we can see how they are attached? Obscure confidential information.

We need to understand if you have modified the Issue Type Hierarchy so that Feature is considered a "parent" of the Story, by Jira, or if you have instead used generic issue linking.

[shib saha]

Hi @Christine Darczyn , Here is the atlassian documentation for writing JQL(Jira Query Language) which can be used to filter and sort data with complex requirement.

https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Hope this will be helpful! Thanks

[Christine Darczyn]

thank you!