如何在FlutterFire中使用.where()对Firestore执行查询？

Hey there! I totally get how frustrating it can be when official docs don’t cover the exact use case you’re working on. Let’s walk through how to use the .where() method in FlutterFire to query Firestore, with practical examples that cover common scenarios.

Basic Syntax #

First, the core structure: you start by referencing your Firestore collection, then chain the .where() method to filter documents based on a specific field, operator, and value. Here’s the simplest form:

// Reference your collection
final usersCollection = FirebaseFirestore.instance.collection('users');

// Create a query: find users where 'age' equals 25
final ageQuery = usersCollection.where('age', isEqualTo: 25);

Common Query Operators & Examples #

Firestore supports several operators to build different types of filters. Here are the most useful ones with code snippets:

• isEqualTo: Match documents where the field exactly matches a value

  // Find users with the role 'admin'
  final adminQuery = usersCollection.where('role', isEqualTo: 'admin');
  

• isGreaterThan/isLessThan: Match values above or below a threshold

  // Find users older than 30
  final over30Query = usersCollection.where('age', isGreaterThan: 30);
  
  // Find posts with fewer than 100 likes
  final lowLikesQuery = FirebaseFirestore.instance.collection('posts')
      .where('likes', isLessThan: 100);
  

• arrayContains: Match documents where an array field includes a specific element

  // Find users who have 'hiking' in their hobbies array
  final hikingLoversQuery = usersCollection.where('hobbies', arrayContains: 'hiking');
  

• arrayContainsAny: Match documents where an array field includes any element from a list

  // Find users who like either hiking or painting
  final hobbyQuery = usersCollection.where('hobbies', arrayContainsAny: ['hiking', 'painting']);
  

• whereIn: Match documents where the field value is in a specified list

  // Find users located in New York or London
  final locationQuery = usersCollection.where('city', whereIn: ['New York', 'London']);
  

Fetching Query Results #

Once you’ve built your query, you can either fetch results once or listen for real-time updates:

One-Time Fetch #

Use get() to retrieve documents once:

try {
  final querySnapshot = await ageQuery.get();
  // Loop through matching documents
  for (var doc in querySnapshot.docs) {
    print('User ID: ${doc.id}, Data: ${doc.data()}');
  }
} catch (e) {
  print('Error fetching documents: $e');
}

Real-Time Updates #

Use snapshots() to listen for changes to the query results (great for live UIs):

// Listen for real-time updates to the admin user list
adminQuery.snapshots().listen((querySnapshot) {
  querySnapshot.docs.forEach((doc) {
    print('Updated admin data: ${doc.data()}');
  });
});

Combining with Other Query Methods #

You can chain .where() with other methods like orderBy() or limit() to refine your results further:

// Find users older than 25, sort by age ascending, limit to 10 results
final sortedQuery = usersCollection
    .where('age', isGreaterThan: 25)
    .orderBy('age')
    .limit(10);

Note: If you get an index error here, Firestore will throw an error with a prompt to create the required composite index in the Firebase Console—just follow that prompt to set it up.

Key Things to Remember #

• You can’t use multiple range operators (like isGreaterThan + isLessThan) on different fields in the same query (unless one of them uses arrayContains).
• String queries are case-sensitive—make sure your filter values match the case of the data stored in Firestore.
• Double-check your Firebase Security Rules to ensure they allow read access to the queried collection.

内容的提问来源于stack exchange，提问作者Tsortanidis Christos