How to use startAt() and endAt() in Cloud Firestore?

Question

I read Dan McGrath's answer from this question in which he says that in Firestore there is an equivalent for the following line of code:

myRef.startAt(searchText).endAt(searchText + "\uf8ff");

This line works perfect in Firebase Realtime database but I'm trying to find the equivalent in Cloud Firestore for days. Can anyone help me with that?

Thanks in advance!

Answer 1

You have a couple of options.

Query filters

You can add query filters using the .where keyword. Take a look at Order and Limit Data with Cloud Firestore

Query cursors

If you want to use cursors for paginating data, take a look at Paginate Data with Query Cursors

Your query

You need to specify which field you are wanting to search. For example, if you're looking for all documents with a name containing the searchText you will need to add an orderBy parameter.

myRef.orderBy("name").startAt(searchText).endAt(searchText + "\uf8ff");

This assumes that your myRef is a reference to a collection.

Answer 2

you find the solution, maybe you confuse, just change this " with single quotes (') and it will works perfectly thanks for the other post it helps me too. I leave my code here:

FirestoreRecyclerOptions <Ingreso> newoptions = new FirestoreRecyclerOptions.Builder<Ingreso>()
                .setQuery(fStore.collection("DatosEmpresa").orderBy("DepartamentoEmpresaLoweCase").startAt(newText.toLowerCase()).limit(25).endAt(newText.toLowerCase()+'\uf8ff'),Ingreso.class)
                .build();