Firebase warning: Using an unspecified index when search data with Firebase Cloud Function

Question

I built a Firebase Cloud Function that looks for users who has value of 'IsNotificationEnabled' equal to true . Part of my Function

export const sendPushNotification = functions.https
.onRequest(async (req, res) => {
    try {
        const { message } = req.body;
        var usersRef = firebase.ref('/Users');
        var usersPushNotificationTokensRef = firebase.ref('/PushNotificationTokens')

        var listUsersSendNotifications = [],
            usersWithTokenSendNotifications = [],
            promises = [];
        if (message) {
            await usersRef.orderByChild('IsNotificationEnabled').equalTo(true).once('value', (snapshot) => {
                snapshot.forEach((childSnapshot) => {
                    console.log(childSnapshot.key)
                    listUsersSendNotifications.push(childSnapshot.key)

                    return false;
                })
            })
            ..........................

as you can see here I'm looking users where IsNotificationEnabled = true. when I run it I get in logs

[2018-05-22T09:12:57.352Z] @firebase/database: FIREBASE WARNING: Using an unspecified index. Your data will be downloaded and filtered on the client. Consider adding ".indexOn": "IsNotificationEnabled" at /Users to your security rules for better performance.

the rules I insert in firebase console

    {
  "rules": {
     ".indexOn": ["IsNotificationEnabled"],

    "Users":{
      "$uid":{
      ".indexOn": ["IsNotificationEnabled"],
        ".write": "$uid === auth.uid",
        ".read": "$uid === auth.uid"
      }


    },
    ".read": true,
    ".write": true
  }
}

I'm missing the question in your question. But doesn't the indexon need to be one level higher? Below Users instead of $uid. — André Kool
my question, why I get this error and how to fix it. I edited my post and add image of users structure — Manspof
Did you try putting the indexon below users instead of $uid? — André Kool

Frank van Puffelen Frank van Puffelen · Accepted Answer · 2018-05-22T13:59:34

As the message says, you'll need to add the index to /Users. You're now adding it one level lower, where it won't work.

{
  "rules": {
    "Users":{
      ".indexOn": ["IsNotificationEnabled"]
    },
    ".read": true,
    ".write": true
  }
}

I find it easiest to remember where to define an index by thinking of where I run my query. Since your query runs on /Users, you need to define your index on that level.

I also remove your .read and .write rules on /Users/$uid, since they are ineffective. You're granting full read/write access at the root already, and permission cannot be taken away at a lower level.

Firebase warning: Using an unspecified index when search data with Firebase Cloud Function

1 Answers