nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL Question

Swapnil Wale

Hello,

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!

Accepted answers

Swapnil Wale

Hi all,

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!

@Danielle Green @Nic Brough -Adaptavist-

All comments

Danielle Green_1lthiv

Hi Swapnil

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

Danielle

Nic Brough -Adaptavist-

Remove the tilde, it is a matching operator, but you already have one with 'in'

Swapnil Wale

Hi all,

Thank you for your responses.

Is that possible?

Thank you again!

@Danielle Green @Nic Brough -Adaptavist-

Nic Brough -Adaptavist-

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?

NTAMEN NTANMI luc landry

@Nic Brough -Adaptavist- hello please how can i practice in jql?

Nic Brough -Adaptavist-

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server