Requête avec lien avec sous-tâche

Florence BELHENNICHE December 29, 2020

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

1 answer

1 accepted

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 29, 2020

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 December 31, 2020

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 31, 2020

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 December 31, 2020

Thanks ! You Too

Florence

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events