SQL LIKE operator in Cloud Firestore?

database firebase google-cloud-firestore
Manjok picture Manjok · Oct 9, 2017 · Viewed 22.6k times · Source

I have been using Firebase Real Time Fatabase for a while and I come across Cloud Firestore today. I can't figure out on how to use LIKE operator on Firestore.

Firebase Real Time Database

ref.child('user').orderByChild('name').startAt(name).endAt(name+'\uf8ff')

On Cloud Firestore, I have tried 

userRef.where('name', '>=', name); <br>
userRef.where('name', '<=', name);

But it doesn't work.

Answer

Ioana P. picture Ioana P. · Mar 12, 2018

To solve this, you need to change orderByChild function with orderBy. So please use the following code:

ref.collection('user').orderBy('name').startAt(name).endAt(name+'\uf8ff')

Related questions

Difference between set with {merge: true} and update

In Cloud Firestore there are three write operations: 1) add 2) set 3) update In the docs it says that using set(object, {merge: true}) will merge object with existing one. The same happens when you use update(object) So what is the …

Read More
How to get a count of number of documents in a collection with Cloud Firestore

In Firestore, how can I get the total number of documents in a collection? For instance if I have /people /123456 /name - 'John' /456789 /name - 'Jane' I want to query how many people I have and get 2. I could do …

Read More
Firestore: How to get random documents in a collection

It is crucial for my application to be able to select multiple documents at random from a collection in firebase. Since there is no native function built in to Firebase (that I know of) to achieve a query that does …

Read More