0

I made a app where I can see the university name for my bachelor available for me depending on my secondary and higher secondary result. So, I made a database(UniInfo) with three attribute (universityName, secondaryResult, higherSecondaryResult). Here user will input their secondary and higherSecondary result and can see the available university list.

If i write my query with sql, then -

SELECT universityName
FROM UniInfo
WHERE inputSecondaryResult >= secondaryResult 
  AND inputHigherSecondaryResult >= higherSecondaryResult;

But I made this app with Firebase which is nosql database. In nosql we can not retrieve data with multiple clause (AND operation). Help me out to write this query. Thanks.

Frank van Puffelen
  • 565,676
  • 79
  • 828
  • 807
Adil Chowdhury
  • 335
  • 1
  • 5
  • 18
  • I saw that earlier. Its not helping me as the type of attributes here is string and my result attribute type is double. So, I can't merge the values and put it on different index. – Adil Chowdhury Jan 24 '19 at 17:39
  • There is no way to do that type of query in one go on the database, since even with synthetic multi-value properties you can only do one range filter. The linked answer explains your other options, which is: do one of the filters on the client. – Frank van Puffelen Jan 24 '19 at 17:58

0 Answers0