You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Please help me with this:
category = DEV and Assignee = currentUser() OR status changed AND project = CERT AND issueTypein standardissueTypes() AND due< endOfWeek(-1)
This is an example within my exam prep.
Hello @Michael Gold , we aren't sure what you are specifically asking for here. If you want to know how to read this query let's break it down:
The "OR" is definitely something to be careful of, especially if you do not see parentheses. Without parentheses, you could easily get different results than what you were expecting.
Humans are very bad at logic, and we tend not to understand how our language around logic is poor and hence when we ask a computer to answer a logic question, we often fail to understand what we're actually saying to them.
My bet is that your query is working fine, but because you have used both and and or to join clauses, you don't actually understood what you have asked of the computer. (If you were using all "and", then you're asking "show me issues that match all the criteria", if it were all "or", the question would be "show me issues that match any of the criteria")
The computers simply read left to right when they get a query, so I'm 99% certain that you're not meaning to use the or in the middle as it has been. In fact, because it's so hard to grasp what you've actually said to the computer, I've never learned to read them, I always write clarified JQL.
You clarify with parentheses. I can't tell what your query is actually supposed to be asking, but one of the easy to explain ones would be
( category = DEV and Assignee = currentUser() ) OR ( status changed AND project = CERT AND issueTypein standardissueTypes() AND due< endOfWeek(-1) )
This would be : list all the issues that are either
The parenthesis make how the clauses join up crystal clear to humans and the computers.