Filtering by organizations empty

[Silviu VARODI]

Hello,

I asked my coworkers to define the organization when a ticket is created, but most of them forgot or dont do it. So I have to correct that.

In the advanced search, I'm trying to filter all my tickets when the organizations field is empty but without success. Can you help me with that please ?

Regards,

[Jack Brickey · Accepted solution]

Have you tried the following JQL?

Project = myproject and Organizations = empty

change myproject to reflect your project

[Silviu VARODI]

Yes, perfect ! Thanks a lot ! :)

[Suvradip Paul]

That's pretty simple and straight forward. Please keep this support document - https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/ for future reference with JQL Fields, Functions, Keywords and Operators.

[Ingo Wenke]

We use Automation for this story.

Update organization on behalf of reporters domain. (This is an out-of-the-box action in Automation).

We added 3 triggers:

1. manual trigger

2. sceduler

3. automatically when issue is created

[Joe Pitt]

Through years of experience with Jira and other tools, you must make a field required at creation time if you want it then. 

[Silviu VARODI]

Yes, when they create the ticket, most of time there is no problem, the organization is set. They mostly forgot to set it when a customer sent an email. So, I'll try to make a rule at creation time, but there is a way to auto-fill the organization field when the customer send an email ?

[Silviu VARODI]

Or maybe is there a way to auto-fill the organization when my coworkers choose the username ?