CODEWITHSUNDEEP
firebase-realtime-databasefilter
Zippy
Zippy

Reputation: 495

firebase database filtering is not working. Need some assistance

I have a simple test database that I cant get to filter. I indexed the category in the rules:

"questions":{
        ".indexOn": ["category"]
      },

My filter for the quiz app:

/questions.json?orderBy="category"&equalTo="Basics"&print=pretty

and my database:

"-MKoucSP33zm4jC43AnY" : {
    "title" : {
      "answers" : [ {
        "score" : 30,
        "text" : "Pineapple"
      }, {
        "score" : 5,
        "text" : "Ham"
      }, {
        "score" : 20,
        "text" : "Yogurt"
      }, {
        "score" : 10,
        "text" : "Crab"
      } ],
      "category" : "Basics",
      "questionId" : "101",
      "questionImage" : "",
      "questionLink" : "",
      "questionText" : "What topping do you like the best on pizza?"
    }
  }

Upvotes: 0

Views: 30

Answers (1)

Frank van Puffelen
Frank van Puffelen

Reputation: 598728

The category property is nested under the title node, so the property you need to order/filter on is title/category:

/questions.json?orderBy="title/category"&equalTo="Basics"&print=pretty

You'll also need to update your index definition for that path, so:

"questions": { ".indexOn": "title/category" }

Working example: https://stackoverflow.firebaseio.com/64596200/questions.json?orderBy="title/category"&equalTo="Basics"

Upvotes: 1

Related Questions