我有一个无法过滤的简单测试数据库。我索引了规则中的类别:
"questions":{
".indexOn": ["category"]
},
我的智力竞赛应用程序过滤器:
/questions.json?orderBy="category"&equalTo="Basics"&print=pretty
和我的数据库:
"-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?"
}
}
category
属性嵌套在title
节点下,因此需要排序/筛选的属性为title/category
:
/questions.json?orderBy="title/category"&equalTo="Basics"&print=pretty
您还需要更新该路径的索引定义,因此:
"questions": { ".indexOn": "title/category" }
工作示例:https://stackoverflow.firebaseio.com/64596200/questions.json?orderBy="标题/类别"&equalTo=";基础知识";