Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Nesting JQL to setup a queue

Ste404
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2022

Hi there,

I am trying to set up a queue in JSM for the 'Service Operations' team, but I want to exclude issues where the Request Type is 'Capex Request' and the status is 'Pending'

resolution = Unresolved AND Queue in iqlFunction("Name = \"Service Operations\"") OR (("Request Type" = "CAPEX Request (ISMT)" AND status != Pending))

That is what I have so far but it isn't working and I am not sure how to show all their unresolved tickets but only strip out that particular subset?

 

Thanks

1 answer

0 votes
Fernando Eugênio da Silva
Community Champion
September 8, 2022

@Ste404 

Just use this:

"Request type" != "CAPEX Request (ISMT)" AND status != "Pending" OR resolution = unresolved AND Queue in iqlFunction("Name = \"Service Operations\"")

This will cause any issues other than "CAPEX Request (ISMT)" in "Pending" status to appear in the queue.

Remember that if the request type "CAPEX Request (ISMT)" is in any status other than "Pending", it will now appear in your queue.

Hope this helps :)

Ste404
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2022

The Pending issues still appear in the queue.

Capture.JPG

Fernando Eugênio da Silva
Community Champion
September 9, 2022

uh! my bad my bad:

Follow the query updated

"Request type" != "CAPEX Request (ISMT)" AND status != "Pending" OR resolution = unresolved AND Queue in iqlFunction("Name = \"Service Operations\"") AND Request type" != "CAPEX Request (ISMT)" AND status != "Pending"

Ste404
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 12, 2022

Hey, sorry for the delay I have been unwell.

I am looking at this update but now the queue won't load.  Not clear enough on the changes to see what is stopping it from displaying any results now.

 

EDIT - found it, there was a missing "

Thank you for your time, this does what it should be doing now.

 

Greatly appreciated and I have learnt some snazzy things about JQL also here :)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events