How to filter where "Request Type" = ""?

[Martin Fuller]

How to filter where Request Type is blank? I can see there are some issues where Request Type is blank, so how can I find all of them?

Attempt 1: project = ... AND issuetype in (Change, Problem) AND "Request Type" = ""
Response: "There are no customer request types that match . Use the JQL auto suggestions to find the customer request type you're looking for."

Attempt 2: project = ... AND issuetype in (Change, Problem) AND "Request Type" = null
Response: "No issues were found to match your search".

Attempt 3a: project = ... AND issuetype in (Change, Problem) AND "Request Type" not in (<all the nonblank values>)
Attempt 3b: project = ... AND issuetype in (Change, Problem) AND "Request Type" != "<value>" and "Request Type" != <each of the nonblank values>
Response: "No issues were found to match your search".

Attempt 4: project = ... AND issuetype in (Change, Problem) ORDER BY "Request Type"
Response: "Field 'Request Type' does not support sorting."

Partial answer: Export the full list to Excel and filter there. But the export only allows 1000 items...

[Marko Blagus · Accepted solution]

Hello @Martin Fuller

To check if request type is empty, use JQL: cf[10021] is EMPTY.

Best regards,

Marko Blagus

[Martin Fuller]

Explanation:

cf[10021] is the custom id for "Request Type" in my project.  This version of the query did work for me.

"Request Type" is empty didn't work for me (it returned no rows) although it should be identical.

[Mathew Lederman]

@Martin Fuller Are you looking for the JSM field 'Request Type' that determines which portal submission form was used? Or a custom field called 'Request Type'? 

If the former, use 'Customer Request Type' is empty

If the latter, use 'Request Type' is empty.

Either way, I would recommend adding the field to the viewable columns so you can confirm if any of your queries are making an impact.

[Marko Blagus]

Hello Martin,

Did you try "Request Type" is EMPTY?

Best regards,

Marko Blagus

[Martin Fuller]

project = ... AND issuetype in (Change, Problem) and "Request Type" is EMPTY

Response: "No issues were found to match your search"

[Mathew Lederman]

@Martin Fuller can you provide a screenshot with a ticket that has the Request Type field populated? Ignore this, you just did

[Martin Fuller]

[Mathew Lederman]

That field is actually 'Customer Request Type' despite the title showing 'Request Type'.

"Customer Request Type" is empty 

[Martin Fuller]

"Request Type" works for non-blank values and "Customer Request Type" doesn't work at all.

project = ... AND issuetype in (Change, Problem) and "Request Type" = "Underlying Problem"

Response: 1–50 of 1000+ (and they all show "Underlying Problem")

project = ... AND issuetype in (Change, Problem) and "Customer Request Type" = "Underlying Problem"

Response: "Field 'Customer Request Type' does not exist or you do not have permission to view it."

Same for "Customer Request Type" is empty.

[Marko Blagus]

It works for me because my CF is called "Request Type" and I tested it on my testing instance and it works.

This shows how I entered my JQL and it returned my only issue with empty "Request Type" field.

[Mathew Lederman]

I would suggest using the basic search to identify the correct field (if you have multiple called "Request Type" you may need to add the custom field ID) and then try the "is empty" function

[Martin Fuller]

"To search by Request Type please switch to advanced."

Syntax Help within JQL tells me there is only 1 field matching "Request Type" and the id is cf[10021].

[Marko Blagus]

Hey @Martin Fuller 

Did you try JQL with that value: cf[10021] is EMPTY?

Best regards,

Marko Blagus

[Martin Fuller]

Thank you, that works.

It's maddening that all the other ways don't work.

[Mathew Lederman]

Agreed

[Marko Blagus]

@Martin Fuller I'm glad it works :D

[Martin Fuller]

@Marko Blagus The system wants me to accept an answer but there is no way to accept a reply.  If you post an answer that suggests the custom id as well as "Request Type", I'll accept that.