How to write .indexOn for Nested values in firebase?

Question

enter image description here

I have wrote on below rules for Get the value form chats with key createdAt But i cant able to get the values from Firebase DB. Rules are Below

"chats": {
  ".read" : true,
  ".write" : "auth !== null",
      "messages" : {
            ".indexOn": ["userName", "createdAt", "userId"]
        }
},

chats/messages.json?orderBy="createdAt"&startAt=1485920224250&print=pretty

Could you please edit your original post to clarify what your question is? Your title says you want to write a rule to index nested values in Firebase, but later in your post you say you can't get values. Something else is wrong if you are not returning data from Firebase. — Drew Szurko
– Drew Szurko, Commented Apr 15, 2017 at 15:15
I have write the rules for chats/messages.json?orderBy="createdAt"&startAt=1485920224250&print=pretty, but firebase doesnt return anything, kindly advice me what rules need to add in firebase — R Rajan
– R Rajan, Commented Apr 15, 2017 at 16:09

Frank van Puffelen · Accepted Answer · 2017-04-15 14:41:18Z

2

You're missing a level in your rules:

"chats": {
  ".read" : true,
  ".write" : "auth !== null",
  "$chatId": {
      "messages" : {
            ".indexOn": ["userName", "createdAt", "userId"]
        }
  }
},

answered Apr 15, 2017 at 14:41

Frank van Puffelen

603k85 gold badges895 silver badges868 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

R Rajan Over a year ago

I Have tried your solution but it throw some error { "error" : "Index not defined, add \".indexOn\": \"createdAt\", for path \"/chats/messages\", to the rules" }

Frank van Puffelen Over a year ago

Yeah, I see now that you're trying to get chat rooms based on the timestamp of the messages in them. That won't work. If you want to get the chat rooms in the order of when they were last updates, you must have a property on the chat room that indicates when it was last updated.

Emanuela Colta Over a year ago

@FrankvanPuffelen, but what about indexing both chats AND messages?

Collectives™ on Stack Overflow

How to write .indexOn for Nested values in firebase?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related