nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issue with Organizations / Service Desk Organisations

Matthew Underwood

Hi,

I need a way searching for JIRA items where the Organizations AND Service Desk Organisation fields are EMPTY / NULL / BLANK - however you want to put it.

I'm sure that the following JQL used to work but it no longer brings back any information.

project = "ISSCC" AND labels in (ISSUE, BUG) AND created >= 2018-01-01 AND "Service Desk Organisation" IS EMPTY

If I run "Service Desk Organisation" IS EMPTY on it's own I do get results just not when combined with other filters. This is no good for me.

I am using JIRA v7.13.1

I have never however, been able to figure out how to search for Organizations that have nothing entered.

When adding this in JIRA all I get are the following four options:

not in

See attached. Default options.JPG Using IS.JPG

Any advice would be gratefully received.

Thanks,

Matt Underwood.

Accepted answers

All comments

Jack Brickey

Try Organization = empty. I was surprised it worked for me TBH as I would have expected the proper syntax to be “is”

Susan Hauth _Jira Queen_

Wow Jack, I've spent the last two years wondering why Organizations is EMPTY didn't work. But Organizations = EMPTY does! That is not proper JQL but it works.

Jack Brickey

bizarre right! i think i will check JAC and open one if not there. a bit of a nit but geez. :-(

Matthew Underwood

Many, many thanks Jack - really grateful for your help with that and good to see that the solution has helped Susan too!

Now, because I want the moon on a stick(!) can you also help with the "Service Desk Organisation" issue I also have?

I have a filter with a few simple bits of JQL:

project = "BLAH" AND created >= 2018-01-01

I have then created a Rich filter and one of the static filters is:

"Service Desk Organisation" is EMPTY

When I run this through the Rich Filter Controller gadget in a dashboard I get no results.

When I run the same JQL separately I do get results - 6,753 of them.

With results.JPG

When I add in further JQL to the above query it also returns 0 results. Unfortunately I know there are plenty of Critical issues in our JIRA project!

No results.JPG

Once again any help would be greatly appreciated.

Many thanks,

Matt.

Susan Hauth _Jira Queen_

@Jack Brickey , found one suggestion for Server:

https://jira.atlassian.com/browse/JSDSERVER-5289

Jack Brickey

thanks. i open a support ticket as i didn't find anything for cloud. i will update the request w/ that info as they may wish to simply extend that for cloud.

Jack Brickey

and now there is a cloud variant - JSDCLOUD-8107

Susan Hauth _Jira Queen_

And Atlassian linked them super quick!!

Will(y) De Vos

Hi all,

any suggestions on how I filter on a combination of the following situation?

Display a list of all tickets that are NOT belonging to organizations "X" & "Y" and are NOT "Empty". Sometimes it happens that the "organization" is not filled in when the reporter has a free domain address.

I'm struggling with the combination...

Thanks for your feedback.

Aman Sharma_p9m2s1

Organizations in (EMPTY)

Aman Sharma_p9m2s1

@Will(y) De Vos ,

Please try this

Organizations not in (EMPTY) AND Organizations !="X" AND Organizations != "Y"

Jack Brickey

Nils Boe Eriksen

Yup, that syntax works

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk