What is the JSON format for a firestore individual field index within a collection group query?

Question

We can now retrieve documents from a collection group which is great. To do so, I need to create an index through an error message on the Firebase console. How can I add this new index to the firestore.indexes.json file?

Example of the documentation:

let museums = db.collectionGroup('landmarks').where('type', '==', 'museum');
museums.get().then(function(querySnapshot) {
  querySnapshot.forEach(function(doc) {
    console.log(doc.id, ' => ', doc.data());
  });
});

if you add added through the firebase console, it will auto sync with your project if you are using the cli tool — andresmijares, Jun 03 '19 at 13:42
interesting @DougStevenson I always asked how come they appeared on my projects then — andresmijares, Jun 03 '19 at 14:12
That only works when you firebase init for the first time. After that, there is no sync. — Doug Stevenson, Jun 03 '19 at 14:13

score 11 · Accepted Answer · answered Jun 03 '19 at 14:51

At the top level of your index file, add a new element called fieldOverrides and populate it like this:

{
  "fieldOverrides": [
    {
      "collectionGroup": "landmarks",
      "fieldPath": "type",
      "indexes": [
        {
          "order": "ASCENDING",
          "queryScope": "COLLECTION"
        },
        {
          "order": "DESCENDING",
          "queryScope": "COLLECTION"
        },
        {
          "arrayConfig": "CONTAINS",
          "queryScope": "COLLECTION"
        },
        {
          "order": "ASCENDING",
          "queryScope": "COLLECTION_GROUP"
        }
      ]
    }
  ]
}

This preserves the all the default automatic indexing for the type field in landmarks at the COLLECTION scope, and allows for type also to be used at the COLLECTION_GROUP scope.

If you found this answer helpful, please accept it as correct. — Doug Stevenson, Jun 03 '19 at 16:25

What is the JSON format for a firestore individual field index within a collection group query?

1 Answers1

Linked