Requête avec lien avec sous-tâche

Florence BELHENNICHE

Bonjour,

j'aimerais faire la requête suivante dans Jira :

Obtenir tous les Jiras du projet X pour lesquels :

- il existe une sous-tâche de statut 'terminé' dont la description contient le mot 'report'

ET

- il existe une sous-tâche de statut non 'terminé' dont la description contient le mot 'construction'

Pouvez-vous m'aider svp ?

Merci

FB

Bill Sheboy

Hi @Florence BELHENNICHE  -- Welcome to the Atlassian Community!

If I understand your request correctly, you want to:

Return all issues in project <X>
 (
   (Which have a sub-task where status IN (Completed) AND Description ~ "report")
   OR
   (Which have a sub-task where status NOT IN (Completed) AND Description ~ "construction")
)

If that is correct, you cannot do that with out-of-the-box Jira.  The JQL isn't a real SQL, so you would need a marketplace scripting add-in to do this.  Perhaps something like ScriptRunner.

If you just need to do this once, as a work-around you could export the issues from Project <X> to a spreadsheet and perform the query using formulas there.

Best regards,

Bill