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.
Join now to unlock these features and more
I've been using the following JQL: type = bug AND component = example AND key in (XYZ-1212) and created >= 2022-10-01 and assignee = asmith ORDER BY created DESC and as a result I've gotten one ticket that is XYZ-1212.
I tried to use a slightly different JQL: type = bug AND component = example AND key in ~ (1212, 1213, 1214) and created >= 2022-10-01 and assignee = asmith ORDER BY created DESC and expected to get 3 tickets as a result but instead received an error saying: "Error in JQL Query: Expecting either a value, list or function but got '~'. You must surround '~' in quotation marks to use it as a value." .
Does anyone know how to solve this error?
Thank you in adavance!
Thank you for your responses.
Let me explain what I'm looking for: I would like to only write the number of the JIRA ticket, w/o the project prefix. So for example: 1212 instead of XYZ-1212, and then get as a result all the tickets that are numbered 1212. The assignee name will ensure that only the XYZ project tickets will appear.
Is that possible?
Thank you again!
No, it's not possible.
I don't think it has any use either. Project sequence keys are unique to the project. Why would ABC-1212 have anything in common with XYZ-1212?
Best way to learn JQL is to play with it. Ask your people what they are looking to report on, and then build JQL to find the issues they want to report on.
Components don't have transitions, so I'm a bit stuck on what you mean.
What are you trying to find through your JQL query? Because defining the key in your query will then just return that ticket or tickets, and make the rest of the query redundant.
If you did want to get the 3 tickets, then the syntax for the clause (or just the whole query really) should be:
key in (XYZ-1212, XYZ-1213, XYZ-1214) [no ~ ]
key >= XYZ-1212 and key <=XYZ-1214
Remove the tilde, it is a matching operator, but you already have one with 'in'