i want to use where in query

[Paresh Magar]

I have a query that returns Feature numbers (Epic Links as Key). I want to use this query in another query to return me stories under the list of features returned by earlier query

[Cristiano Alves -Appfire-]

Hello @Paresh Magar ,

Cristiano, from the Appfire team here.

Using JQL Search Extensions for Jira, you will be able to query for stories under the list of features from your previous query saved as a filter.

The following query should help you out with that:

issues in childrenOfIssuesInQuery("filter='Epic Keys'") AND issuetype = Story

 Feel free to contact our support if you have any questions about this query or our plugin.

Regards.

[Gerusa Lobo _e-Core_]

Hi @Paresh Magar

Maybe you can use something like that:

issue in portfolioChildIssuesOf("ABC-123") and issuetype = 'Story'

portifólio function getting all childs and child of childs up to subtask from a Epic, Feature or Initiative.

Another approach could be grouped issues based on a label, version or a customfield.

Regards.

[Marc - Devoteam]

Hi @Paresh Magar 

Welcome to the community.

JQL doesn't support the keyword where.

What you want to achieve is not possible with ootb JQL, you will need to look at 3rd party marketplace apps like;

JQL search extensions or JQL tricks