FireBase Rules indexOn Issue

Question

I am trying to get all emails of users using firebase Query like below

private void searchUserByEmail(final String searchText) {  
        DatabaseReference mFirebaseDatabaseReference = FirebaseDatabase.getInstance().getReference();
        Query query = mFirebaseDatabaseReference.child(Constants.FB_TABLE_USERS).orderByChild(Constants.FB_EMAIL).equalTo(searchText);
        query.addListenerForSingleValueEvent(new ValueEventListener() {
}}

And While Searching Any email Which is not in list I am getting a warning message in my console Like

W/PersistentConnection: pc_0 - Using an unspecified index. Consider adding '".indexOn": "email"' at table_users to your security and Firebase Database rules for better performance

And My Rules in FireBase is

{
  "rules": {
    ".read" : "auth != null",
    ".write" : "auth != null",
    "table_users": {
      ".indexOn": ["email"]
    }
  }
}

This is my Users Table screenshot

@Ali Yes i Tried in that way also but i didn't get any response from firebase — Raj Kumar
"i didn't get any response from firebase" do you mean the warning not shown ? — Ali Faris

Ali Faris Ali Faris · Accepted Answer · 2018-01-24T08:00:33

you should remove the brackets from ".indexOn" value

"table_users": {
  ".indexOn": "email"
}

query.addListenerForSingleValueEvent(new ValueEventListener() {

    @Override
    public void onDataChange(DataSnapshot dataSnapshot) {
        for (DataSnapshot snapshot : dataSnapshot.getChildren()) {
            String email = snapshot.child("email").getValue();
            System.out.print(email);
        }
    }
});

FireBase Rules indexOn Issue

1 Answers