Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events