Firestore多条件查询失效求助：日期范围+额外筛选解决方案

Hey there! I see you're trying to query Firestore with a date range and an additional name filter, but running into issues. Let's break down why this isn't working and how to fix it quickly.

The Core Issue: Required Composite Index #

Your query logic is actually correct on the surface—combining a range filter on validity with an equality filter on name is allowed in Firestore. The problem is that Firestore requires a composite index for any query that combines a range condition with one or more equality conditions. Without this index, the query will fail silently (or throw an error you might not be catching yet).

Step-by-Step Fixes #

• Use Firestore's Auto-Generated Index Link (Easiest Way)
  Run your app and trigger the query, then check Android Studio's Logcat. Firestore will print an error message that includes a direct URL. Click that URL, and it'll take you straight to the Firebase Console where you can create the required index with one click. The console automatically pre-fills all the correct fields for your query—just confirm and save.

• Manually Create the Composite Index
  If you prefer to set it up yourself:

  1. Go to the Firebase Console for your project, navigate to Firestore Database → Indexes.
  2. Click "Create Index", select the tagGroup collection.
  3. Add the first field: validity with a sort order (ascending or descending—either works for your range query).
  4. Add the second field: name with ascending sort order.
  5. Name your index (or let Firebase auto-generate it) and save. Wait a few minutes for the index to build—Firestore will notify you when it's ready.

Additional Checks to Avoid Headaches #

• Verify Field Types: Make sure the validity field in Firestore is stored as a Date/Timestamp type, not a string or numeric timestamp. Mismatched types will make your range query return incorrect results.
• Handle Query Failures: Your current code only handles empty results, but not failed queries. Update your onComplete method to catch errors:

  @Override
  public void onComplete(@NonNull Task<QuerySnapshot> task) {
      views.formCommon.fcEnabled(); // Move this here so it runs regardless of success/failure
      if (task.isSuccessful()) {
          QuerySnapshot result = task.getResult();
          if (result != null) {
              for (DocumentSnapshot document : result) {
                  List<String> tags = (List<String>) document.get("uiiList");
                  tagsList.addAll(tags);
              }
          }
          if (tagsList.isEmpty()) {
              showToast("Nothing found", Toast.LENGTH_SHORT);
          } else {
              inventoryList(tagsList);
          }
      } else {
          Log.e("FirestoreQuery", "Search failed", task.getException());
          showToast("Search failed: " + task.getException().getMessage(), Toast.LENGTH_SHORT);
      }
  }
  

• Check Parameter Values: Ensure the name parameter isn't null or empty, and that dateInit is actually before dateFinal—small mistakes here can lead to unexpected empty results.

内容的提问来源于stack exchange，提问作者Caio Fuzatto