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!

[Swapnil Wale · Accepted solution]

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- 

[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.

[Kadambi,S,Sumanth,QDC C]

Hi Nic,

can you suggest a query, where i want to get list of incidents which has passed through a component, may or may have that component as current component.

[Nic Brough -Adaptavist-]

"componenet = xyz" is the basic search.

[Kadambi,S,Sumanth,QDC C]

thanks, i wanted to know how to query for component transitions

[Nic Brough -Adaptavist-]

Components don't have transitions, so I'm a bit stuck on what you mean.

[Kadambi,S,Sumanth,QDC C]

hi , i wanted to create a foot fall report for a component. mean how many tickets passed through the component, which currently may still sit in the component or may not.

[Danielle Green]

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 ~ ]

or

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'