Rest API: Find users with no (null) organizations

[schmanat]

Infos:

• Used Zammad version: 5.2.3
• Used Zammad installation type: ubuntu package
• Operating system: Ubuntu 21.04
• Browser + version: MS Edge 104.0.1293.54, Chrome Enterprise 104.0.5112.102

Expected behavior:

• If i try to search all users with no organizations (organization_id) i get allways no result.

Actual behavior:

I try to get all users with no organizations. This looks like

https://zammad-server.tld/api/v1/users?query=organization_ids:NIL or https://zammad-server.tld/api/v1/users?query=organization_ids:NULL

I get allways an empty array. Is it possible to fetch users with no organization_id’s

Steps to reproduce the behavior:

• Fetch the users endpoint with query params (see above)
• check the result

[MrGeneration]

I’m afraid you can’t search for missing organizations due to Elasticsearch limitations.
You can’t lookup null values. According to the payload it’s a null value if unset.