JQL for counting stories under features from multiple projects

[Jesse Pearlman]

I have a user who is generating a report feature by feature that counts the stories under those features in 4 projects.  Is there a way to use JQL to pull a list of all features and the count of users stories under them from four projects easily if not elegantly?

Halp!  Jira newb on the keyboard

[Valeriia_Havrylenko_SaaSJet]

Hi @Jesse Pearlman 👋

Try JQL query like below :

project in ("A","B","C") AND assignee in ("a","b","c","d","e") AND status not in ("Done","Cancelled") AND resolution = Unresolved

Kindly check Document for more info :- https://www.atlassian.com/software/jira/guides/expand-jira/jql#advanced-search

Hope it helps 😌
Valeriia

[Jesse Pearlman]

@Valeriia_Havrylenko_SaaSJet This gives me a running start but I don't want assignees as part of the query, if I leave that out and then add in the where issuelink 0< or some such?

[Jesse Pearlman]

@Valeriia_Havrylenko_SaaSJet What about this

project in ("A","B","C") AND features in ("a","b","c","d","e") AND status not in ("Done","Cancelled") AND resolution = Unresolved AND feature link <0

[Valeriia_Havrylenko_SaaSJet]

Hi @Jesse Pearlman 
I think this JQL will work. 
Did you try it already?

[Jesse Pearlman]

@Valeriia_Havrylenko_SaaSJet it formed a good start :) Thanks!