Feature child stories/issues

[LUIS MIGUEL DAZA MENDOZA]

I want to create a filter that shows all the features that aren't deployed but have all his child stories/issues in final status (deployed or discarded).

Because of company policies, I can't install plugins or apps

[Bill Sheboy]

Hi @LUIS MIGUEL DAZA MENDOZA 

Short answer: that is not possible with built-in capabilities of JQL.

The built-in Jira Query Language (JQL) does not have features to perform queries as you describe.  That is, it cannot perform a JOIN to test parent / child work items.  For frequent usage, this limitation is often solved with marketplace apps, however you describe being unable to install apps to extend the features of JQL. 

Some possible workarounds include:

• Manual queries
  • Query to find the Features not deployed, creating a list of them. For each one, check the child work items.
• Export the work items and "join" outside
  • Export the Feature work items and any work items which could be children of Features
  • Perform the query / analysis in an external tool: spreadsheet, database, etc.
• For small sample sizes of less than 100 Features, try automation rules
  • Identify the Features with a Scheduled trigger with JQL, a lookup, or a branch
  • For each Feature, identify the children meeting your criteria
  • Send the results in an email, message, etc.

Kind regards,
Bill