Indexing for entire firebase Realtime database?

Asked Mar 14 '23 at 20:35

Active Mar 15 '23 at 16:17

Viewed 32 times

I am using a firebase Realtime database to store basic user info. One of which being their dislikes.

When trying to get the dislikes data, I require it to filter out the false values and only get the values that equal true. However when running it I get the error java.lang.Exception: Index not defined, add ".indexOn": ".value", for path "/users/dG9JqcX2WjgfZhJ3HOFGQyYNrs92/Dislikes", to the rules. I understand I have to add indexing to the path for this users dislikes to the rules for it to work however what about if another user with a different authentication key tries to access theirs? Won't this have a different path so the error will occur for that user until I add indexing for that section? Is there any way to add indexing to the entire database or automate adding the new path to the rules?

I get the dislikes data by using:

myRef.child(userid).child("Dislikes").orderByValue().equalTo(true).get().addOnSuccessListener {

And my database structure looks like this:

Any and all help/tips are appreciated!

edited Mar 15 '23 at 16:17

asked Mar 14 '23 at 20:35

Joshu

Can you please share the complete error message that you get? – Alex Mamo Mar 15 '23 at 07:33
@AlexMamo yes of course – Joshu Mar 15 '23 at 16:17
What is the expected result when you're using that query? – Alex Mamo Mar 16 '23 at 08:16
@AlexMamo, the true values from that path. In this instance... 'cleankng', 'football' and 'gaming' as they are marked tmas true in the database – Joshu Mar 16 '23 at 12:40
So you basically want the query to return only those **two** keys, "Cleaning" and "Football", right? – Alex Mamo Mar 16 '23 at 15:30
@AlexMamo, yes. However if there is another user who has different values that equal true... These are the keys I would need to get – Joshu Mar 18 '23 at 11:02
So you want to query across all users, right? – Alex Mamo Mar 20 '23 at 06:31
@AlexMamo, Yes if possible – Joshu Mar 21 '23 at 20:57
Do you know the value which you are searching for ahead of time? – Alex Mamo Mar 22 '23 at 06:12
@AlexMamo yes, my programs goal is to search for matches in the database of people that have the same dislikes as you. – Joshu Mar 22 '23 at 16:18
It will be a multiple whereEqualTo query or a single one? – Alex Mamo Mar 22 '23 at 18:59
@AlexMamo, Multiple if possible! – Joshu Mar 22 '23 at 21:53
There is no way you can perform multiple whereEqualTo calls in the same query. Please check the duplicate to see a workaround. – Alex Mamo Mar 23 '23 at 07:03

Indexing for entire firebase Realtime database?

0 Answers0