[JSM] JQL that shows where a reporter is not in any Organization

[Andrew Rowland]

I have tried 'organization = empty' but this is not picking up the link of Organization Details linked to the Customer.  This seems to only report on an Organization if the customer has already been associated with an Org prior to the ticket being created.

I use:

"reporter in organizationMembers(Company_A)"

which is great, but I need to find all users who have not been associated with an organization and there doesn't seem to be an option to search for those who are not associated with an Org.

e.g. reporter in organizationMembers(EMPTY)

Does anyone know of a way to do this?

[Adolfo Casari · Accepted solution]

@Andrew RowlandJQL can't handle that, but you can try the REST API:

https://community.atlassian.com/t5/Jira-Service-Management/Is-it-possible-to-get-a-list-of-users-in-an-Organization-through/qaq-p/1387666

[Andrew Rowland]

Thanks for the link, and confirming that JIRA can't manage this style of request.

I'll have to ask the team to review each ticket individually to make sure they are all setup.  Painful process when we have 2000 tickets per month that will need constant validation.

Thanks!

[Adolfo Casari]

You can use an automation rule to mark those tickets whose reporters are not into any organization, using a web request to that API.