IssueTracker

Hi,

Before setting a request, have you tried what the documentation says about ordering and limiting [1]? Here is another question related to your issue [2]. If these pages do not help you, could you please give us an example of what you want to achieve?

[1] https://firebase.google.com/docs/firestore/query-data/order-limit-data [2] https://stackoverflow.com/questions/70148800/using-where-and-order-by-different-fields-in-firestore-query

Hi,

This is a problem with the query where clause. Ordering and limiting doesn't help.

Firestore supports a logical OR with '.where('cities', 'array-contains-any', ['Tokyo', 'Kyoto'])'. This results in documents that contain Tokyo or Kyoto in it's cities array.

Firestore does not support a logical AND such as '.where('cities', 'array-contains-all', ['Tokyo', 'Kyoto'])'. The result should be documents that contain Tokyo and Kyoto in it's cities array.

An example is as follows.

Data

{
  "cities": ["Tokyo", "Kyoto", "Osaka", "Nara"],
  "modified": 1645457445
}

{
  "cities": ["Hakone", "Tokyo"],
  "modified": 1645450245
}

{
  "cities": ["Hiroshima", "Kyoto", "Tokyo"],
  "modified": 1645453845
}

Query

db.collection("blogs")
        .where("cities", "array-contains-all", ["Toyko", "Kyoto"])
        .orderBy("modified", "desc")
        .limit(10)

Expected result

{
  "cities": ["Tokyo", "Kyoto", "Osaka", "Nara"],
  "modified": 1645457445
}

{
  "cities": ["Hiroshima", "Kyoto", "Tokyo"],
  "modified": 1645453845
}

Hi, thanks for your answer.

The Cloud Firestore engineering team is already aware of this request. There is no ETA for a resolution at this time, but all further updates should occur here.

I also need this, I am implementing a simple search with Firestore, searching for records that match one or more (normalised) keywords from a search query.

Currently my workaround is: if the query has one word, I use the keywords array and sort the results as normal. However, if the query has two words, I also store a second copy of the keywords array as a dictionary in { keyword: true } format, and use the dictionary to perform the query rather than the array. This has the downside that it's not possible to order the results (because it would require a compound index, and it is not be possible to include the dictionary of unknown keys in the compound).

In the long run I will probably use a third party search service like Algolia, but for now it is frustratingly difficult to implement a simple search on Firestore.

I would also love to know ETA or at least if this is gonna be implemented at all.

My scenarios involve adding roles with security rules and resources that are protected by a list of permissions that all must be met by a user.

Another scenario requires filtering of resources that are simultaneously shared between several users - in my case I need to show all resources that are shared with an admin (current user) that are also shared with specific clients (other users of the system)

I'm aware of workarounds (like creating an array of full index or reverting to an object), but the limitations there range from being very clunky to impossible at scale.

Any updates on the status of this feature are much appreciated.