IssueTracker

What you would like to accomplish: Ability to query documents with fields that contain empty arrays directly in Firestore. In Firestore, we frequently encounter scenarios where we need to query documents based on the presence of empty arrays in a specific field. Currently, Firestore does not support querying for fields with empty arrays directly. This limitation requires workarounds, such as using additional helper fields or client-side filtering, which can be inefficient and cumbersome.

How this might work:

- Storing permissions in arrays.
- To manage audit permissions effectively, it's required to identify documents where this field is empty.
- Direct querying for empty arrays would significantly simplify our data operations and improve performance.

If applicable, reasons why alternative solutions are not sufficient:

- Reduces complexity in handling data.
- Improves query performance by avoiding unnecessary data fetches and client-side filtering.
- Simplifies application logic and reduces potential errors.

Other information (workarounds you have tried, documentation consulted, etc):

 - https://stackoverflow.com/questions/74862151/firestore-query-returns-empty-array-when-there-is-data-that-should-be-returned
- Helper fields or client-side filtering