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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.