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 · Accepted solution]

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

[Florence BELHENNICHE]

Bonjour Bill,

ma requête est la suivante :

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

Merci pour votre réponse. Je vais me renseigner sur l'outil ScriptRunner auprès de mon entreprise.

Cordialement,

F.B.

[Bill Sheboy]

Thanks for clarifying your request; I misunderstood what you were trying to accomplish and so substituted the OR clause.

I hope that you have a happy new year!

__Bill

[Florence BELHENNICHE]

Thanks ! You Too

Florence