Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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

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

3 answers

1 accepted

0 votes
Answer accepted
Marko Blagus
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.
Nov 08, 2023

Hello @Martin Fuller

 

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

 

Best regards,

Marko Blagus

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.

1 vote
Mathew Lederman
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.
Nov 02, 2023

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

0 votes
Marko Blagus
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.
Nov 02, 2023

Hello Martin,

 

Did you try "Request Type" is EMPTY?

 

Best regards,

Marko Blagus

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

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

Mathew Lederman
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.
Nov 02, 2023 • edited

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

Mathew Lederman
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.
Nov 02, 2023

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

"Customer Request Type" is empty 

"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: 150 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
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.
Nov 02, 2023

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.

Screenshot 2023-11-02 183721.png

Mathew Lederman
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.
Nov 02, 2023

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

"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
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.
Nov 03, 2023

Hey @Martin Fuller 

 

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

 

Best regards,

Marko Blagus

Thank you, that works.

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

Mathew Lederman
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.
Nov 03, 2023

Agreed

Marko Blagus
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.
Nov 04, 2023

@Martin Fuller I'm glad it works :D

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events