Flutter: How to fetch a particular record from firebase

Question

This is the screenshot of my database.

I want to fetch the record for a particular username. (For eg: where [email protected]) Can anyone suggest to me how to fetch this in flutter?

It would be a great help, Thank you.

Answer 1

you can try this approach it helped me, but if you have migrated to null safety just make sure that you change the code accordingly

Answer 2

You can try the following query to get your result.

FirebaseFirestore.instance
  .collection('your-collection-name')
  .where('user', arrayContains: '[email protected]')
  .get();

Answer 3

For android solution follow this:

 FirebaseFirestore.getInstance()
                .collection("users").whereArrayContains("user","[email protected]").get();