You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
Hi
I am doing a data cleanse and needs to find any records that have empty fields that have been updated after a specific date (this year - 2021)
There are 5 fields and I need to filter any records where ALL 5 fields are not populated.
This seems to work but returns records prior to 2021....
updated >= 2021-01-01 AND project = SD AND issuetype = "Service Request" AND component = EMPTY OR "Company[Select List (multiple choices)]" = EMPTY OR "Department[Select List (multiple choices)]" is EMPTY OR "Location[Select List (multiple choices)]" = EMPTY OR Department = EMPTY OR Tags = EMPTY ORDER BY updated ASC, component ASC, cf[10049] DESC, cf[10054] DESC
Cheers
Hi Steve and welcome,
JQL filters can be tricky at first you need to take into account also the AND and OR operators precedence. It seems you missed some ( ) within your filters. I think what you were looking for is:
updated >= 2021-01-01 AND project = SD AND issuetype = "Service Request" AND ( component = EMPTY OR "Company[Select List (multiple choices)]" = EMPTY OR "Department[Select List (multiple choices)]" is EMPTY OR "Location[Select List (multiple choices)]" = EMPTY OR Department = EMPTY OR Tags = EMPTY ) ORDER BY updated ASC, component ASC, cf[10049] DESC, cf[10054] DESC
Note the new ( symbol before component field and the ) symbol before Order by closure.
Regards
Amazing, thank you for the quick response and works perfect, I need to remember that.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have a nice day! I'm sure you'll never forgot to use ( ) properly any more.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan. &nb...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.