I have a database like this (photo attached): Trip has BIDS, and awardedBid. I use awardedBid!=null as a way to determine the trip is still available for bidding. However, I don't know how to query for that condition, so I have to hack by creating another field bidDone so I can use .equalTo, like this

mRootReference.child(CHILD_TRIPS).child(mTripKey).orderByChild(BID_DONE).equalTo(true)

However I feel that's unsafe when I have to use 2 keys to denote just one thing since it's bug-prone (I did create one myself in the attached screenshot where bidDone = false where it should be true).

Is there any cleaner way for that task: query with condition that a string exist?

Thanks

I have a database like this (photo attached): Trip has BIDS, and awardedBid. I use awardedBid!=null as a way to determine the trip is still available for bidding. However, I don't know how to query for that condition, so I have to hack by creating another field bidDone so I can use .equalTo, like this

mRootReference.child(CHILD_TRIPS).child(mTripKey).orderByChild(BID_DONE).equalTo(true)

However I feel that's unsafe when I have to use 2 keys to denote just one thing since it's bug-prone (I did create one myself in the attached screenshot where bidDone = false where it should be true).

Is there any cleaner way for that task: query with condition that a string exist?

Thanks

• javascript
• firebase
• firebase-realtime-database

1 Answer 1

You can remove your attribute bidDone and using startAt() to get all the child having awardedBid not null:

ref.orderByChild("awardedBid").startAt("")

or this to get only the child without bid

ref.orderByChild("awardedBid").endAt(null)