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.
-
Did you try anything yet? If not, have a look at firebase.google.com/docs/firestore/query-data/queries and/or firebase.flutter.dev/docs/firestore/usage#queryingFrank van Puffelen– Frank van Puffelen2021-06-14 22:06:54 +00:00Commented Jun 14, 2021 at 22:06
Add a comment
|
4 Answers
To get the data, you can create a function like:
Future getData(String username) async {
List dataList = [];
try {
await FirebaseFirestore.instance.collection('userdata').where('user', isEqualTo: username).get().then((QuerySnapshot querySnapshot) => {
querySnapshot.docs.forEach((doc) {
itemList.add(doc.data());
}),
});
return itemList;
} catch (e) {
print(e.toString());
return null;
}
}
When you'll call this function, you will have to pass the username and it would return a list of data items.
This list can then be used to show data in the UI as:
child: Text(
title: Text(subjectList[index]['user']),
),
1 Comment
Aditya Thakur
Please refer the FlutterFire - Cloud Firestore usage documentation here: firebase.flutter.dev/docs/firestore/usage
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
Comments
You can try the following query to get your result.
FirebaseFirestore.instance
.collection('your-collection-name')
.where('user', arrayContains: '[email protected]')
.get();
6 Comments
Mahisha Patel
Future<QuerySnapshot> user = FirebaseFirestore.instance .collection('userdata') .where('user', arrayContains: email) .get(); This helps, but also can you tell me how to print my data using user?
Ashok Kuvaraja
If you want to get/ print all the
user key values from the firebase collection. You can simple use the same query without the condition statement arrayContains: email. Future<QuerySnapshot> user = FirebaseFirestore.instance .collection('userdata') .where('user').get();Mahisha Patel
How to get a particular key-value pair? Suppose, I want to get the weight of the user, how to do that?
Ashok Kuvaraja
Hi @MahishaPatel, In Firebase we store the values in map type. So, If you want to get the weight of a user, you should pass the key (weight) into the where method. Like
FirebaseFirestore.instance .collection('userdata') .where('weight').get();Mahisha Patel
When I print user, I just get this :
Instance of 'Future<QuerySnapshot<Map<String, dynamic>>>' |
For android solution follow this:
FirebaseFirestore.getInstance()
.collection("users").whereArrayContains("user","[email protected]").get();
