i am trying to filter loaded database according to different filters inserted by users, these filters may be activated or not in order to do these filtration using firebase i came across some limits that's been discussed here Android firebase apply multiple queries
i have around 5 filters that exists on my application so in order to use the same technique in the answer i would need to do something like that
and by assuming the name can be ideally searched too.
for the answers posted here Query based on multiple where clauses in firebase
i can't also use the create a custom index programmatically solution as my filter do have some dynamic values such as names and some filters may/may not exist
is there any other solution for that?
what is the available approaches using database server to host the database and php script to communicate with it?
- i have no experience in web development
thanks