Advance JQL

[Chamira Lakmal]

How to short below JQL Query

Urgency in (Critical, High, Low, Medium) AND "Request Type" = "Service Request for Application (ICT)" AND "Request Type" = "Service Request for Hardware (ICT)" AND "Request Type" = "Offboard Employees (ICT)" AND "Request Type" = "Create a New Employee Profile (ICT)" AND "Request Type" = "Internal Changes/Promotions (ICT)"

[Jack Brickey · Accepted solution]

I’m unsure what you mean by short. However your JQL is fundamentally flawed because you are “and-ing” your request types. Your RT can only be one value at a time.

Can you explain in words what you’re trying to achieve with this JQL?

[Chamira Lakmal]

Hi Jack,

I mean I want to short 

AND ("Request Type" = "Service Request for Application (ICT)" ,"Request Type" = "Service Request for Hardware (ICT)", "Request Type" = "Offboard Employees (ICT)", "Request Type" = "Create a New Employee Profile (ICT)" , "Request Type" = "Internal Changes/Promotions (ICT)")

I have added the same AND &  "Request Type" in 4times. all are in the same workflow.

But Different Issue types

[Jack Brickey]

I Think that you want the following…

Urgency in (Critical, High, Low, Medium) AND "Request Type" in ("Service Request for Application (ICT)", "Service Request for Hardware (ICT)", “Offboard Employees (ICT)”, "Create a New Employee Profile (ICT)", "Internal Changes/Promotions (ICT)")

[Chamira Lakmal]

Thank You Jack

[Joseph Chung Yin]

@Chamira Lakmal -

The JQL that @Jack Brickey provided is correct.  Please note that Issue Types and Request Types are two different things in JSM.

One issue type can be used for multiple request types setup.

Best, Joseph

[Chamira Lakmal]

Thank you @Joseph Chung Yin 

[Joseph Chung Yin]

@Chamira Lakmal -

If you find my additional note helped your understand, please click on Accept answer when you have a chance.

Best, Joseph

[Ismael Jimoh]

Hi @Chamira Lakmal 

As Jack mentioned your JQL is wrong as issues cannot have multiple request types. 

I am guessing you meant:

Urgency in (Critical, High, Low, Medium) AND ("Request Type" = "Service Request for Application (ICT)" ,"Request Type" = "Service Request for Hardware (ICT)", "Request Type" = "Offboard Employees (ICT)", "Request Type" = "Create a New Employee Profile (ICT)" , "Request Type" = "Internal Changes/Promotions (ICT)")

This performs an OR comparison 

[Ismael Jimoh]

Sorry this is wrong please use @Jack Brickey own