The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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 Champions.
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 Champions.
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 :)

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events