Firebase Auth & Realtime Database Apps · Lektion

Daten filtern und sortieren

Lernen Sie, Daten anhand bestimmter Kriterien zu filtern und Ergebnisse mit Firebase-Abfragen effizient zu sortieren

Daten filtern und sortieren ist eine kostenlose Firebase Auth & Realtime Database Apps-Lektion auf CoddyKit. Dies ist Lektion 2 von 4. Du kannst die komplette Lektion unten kostenlos lesen – dann übst du sie direkt im Browser mit einem integrierten Code-Editor und einem KI-Tutor rund um die Uhr. Sie ist Teil des Firebase Auth & Realtime Database Apps-Lernpfads, und dein Fortschritt wird über Web und CoddyKit-App synchronisiert. Der Firebase Auth & Realtime Database Apps-Kurs umfasst insgesamt 4 Lektionen.

Teile dieser Lektion wurden noch nicht übersetzt und werden auf Englisch angezeigt.

Shape Your Realtime Data

Welcome back! In the Realtime Database, data often needs to be organized or filtered before it's useful. This lesson teaches you how to precisely shape your data.

We'll cover how to sort data using different criteria and filter it to find exactly what you need.

The Need for Precision

Imagine a list of products, users, or messages. Without filtering and ordering, you'd download everything, which is inefficient and slow.

Filtering: Narrows down results to specific criteria (e.g., "products in stock").
Ordering: Arranges results in a meaningful sequence (e.g., "users by name A-Z").

These operations are crucial for building responsive and data-efficient apps.

Sorting with orderBy()

Firebase Realtime Database allows you to order your data using a single orderBy method. You can order by a child key, the item's key, or its value.

orderByChild("keyName"): Sorts by the value of a specified child key.
orderByKey(): Sorts by the unique keys of your data items.
orderByValue(): Sorts by the values of your data items directly (if they are simple values).

orderByChild() in Action

Let's say you have a list of users, each with a "score". You can order them by their score.

Try running this example to see how the query is structured:

public class OrderByChildDemo {
  public static void main(String[] args) {
    System.out.println("--- Firebase Query for Users by Score ---");
    System.out.println("Imagine a database path: 'users'");
    System.out.println("To order users by their 'score' child:");
    System.out.println("  .orderByChild(\"score\")");
    System.out.println("\nThis query prepares to fetch users ordered by 'score'.");
    System.out.println("Real Firebase query would look like:");
    System.out.println("// Query usersByScore = databaseRef.child(\"users\")");
    System.out.println("//                          .orderByChild(\"score\");");
  }
}

Pinpointing Data Filters

Once ordered, you can filter your data. These methods define the range or exact match:

equalTo(value): Finds items where the ordered child/key/value is exactly value.
startAt(value): Starts retrieving items from value onwards.
endAt(value): Stops retrieving items at value.

These are always used after an orderBy method.

Finding Specific Items

If you want to find all users with a specific status, equalTo() is your go-to. It's often combined with orderByChild().

Here's how you'd query for users with a "status" of "active":

public class EqualToDemo {
  public static void main(String[] args) {
    System.out.println("--- Firebase Query for Active Users ---");
    System.out.println("Imagine a database path: 'users'");
    System.out.println("To find users where 'status' is 'active':");
    System.out.println("  .orderByChild(\"status\")");
    System.out.println("  .equalTo(\"active\")");
    System.out.println("\nThis query would fetch users with 'status' set to 'active'.");
    System.out.println("Real Firebase query would look like:");
    System.out.println("// Query activeUsers = databaseRef.child(\"users\")");
    System.out.println("//                         .orderByChild(\"status\")");
    System.out.println("//                         .equalTo(\"active\");");
  }
}

Data within a Range

Need data between two values? startAt() and endAt() are perfect for this. For example, finding products within a price range.

This example shows how to query for items where the "price" is between 10.0 and 50.0:

public class RangeQueryDemo {
  public static void main(String[] args) {
    System.out.println("--- Firebase Query for Price Range ---");
    System.out.println("Imagine a database path: 'products'");
    System.out.println("To find products with 'price' between 10.0 and 50.0:");
    System.out.println("  .orderByChild(\"price\")");
    System.out.println("  .startAt(10.0)");
    System.out.println("  .endAt(50.0)");
    System.out.println("\nThis query would fetch products with 'price' in the specified range.");
    System.out.println("Real Firebase query would look like:");
    System.out.println("// Query affordableProducts = databaseRef.child(\"products\")");
    System.out.println("//                                .orderByChild(\"price\")");
    System.out.println("//                                .startAt(10.0)");
    System.out.println("//                                .endAt(50.0);");
  }
}

Powerful Combined Queries

The true power comes from combining orderBy() with startAt(), endAt(), or equalTo(). Remember:

You can only use one orderBy method per query.
Filter methods like startAt() must correspond to the property you're ordering by.

This ensures efficient indexing and retrieval.

Fetching Top Scores

Let's get the top 5 users with scores greater than 100. This combines ordering, a start filter, and a limit (limitToFirst() or limitToLast(), which are related to pagination but also used for filtering 'top N').

We'll order by score, start at 100, and take the first few results.

public class CombinedQueryDemo {
  public static void main(String[] args) {
    System.out.println("--- Firebase Query for Top Scores ---");
    System.out.println("Imagine a database path: 'players'");
    System.out.println("To get players with score > 100, ordered by score, limited to 5:");
    System.out.println("  .orderByChild(\"score\")");
    System.out.println("  .startAt(100)");
    System.out.println("  .limitToFirst(5)");
    System.out.println("\nThis query would fetch the first 5 players with 'score' >= 100.");
    System.out.println("Real Firebase query would look like:");
    System.out.println("// Query topPlayers = databaseRef.child(\"players\")");
    System.out.println("//                          .orderByChild(\"score\")");
    System.out.println("//                          .startAt(100)");
    System.out.println("//                          .limitToFirst(5);");
  }
}

Optimizing with Indexes

For efficient ordering and filtering on child keys, you need to define indexes in your Firebase Realtime Database Security Rules.

Without indexes, Firebase will download all data and filter/order it client-side, which is slow and costly. Add ".indexOn": ["yourKey"] to your rules for frequently queried fields.

Querying Knowledge Check

Which of the following Firebase Realtime Database query methods are used to filter data based on a specific range or exact value?

Filtering & Ordering Summary

Great job! You've learned how to effectively filter and order data in Firebase Realtime Database.

Use orderByChild(), orderByKey(), or orderByValue() to sort.
Apply equalTo(), startAt(), and endAt() for precise filtering.
Combine these methods for powerful, specific queries.
Remember to add indexes for performance!

Next, we'll explore techniques for handling large datasets using pagination.

Häufig gestellte Fragen

Ist die Lektion „Daten filtern und sortieren“ kostenlos?

Ja — der vollständige Text von „Daten filtern und sortieren“ ist hier im Web kostenlos zu lesen. Um sie interaktiv zu üben (integrierter Code-Editor und 24/7 KI-Tutor) und den Rest des Firebase Auth & Realtime Database Apps-Kurses freizuschalten, upgrade auf CoddyKit PRO. Der Firebase Auth & Realtime Database Apps-Kurs umfasst insgesamt 4 Lektionen.

Was lerne ich in „Daten filtern und sortieren“?

Lernen Sie, Daten anhand bestimmter Kriterien zu filtern und Ergebnisse mit Firebase-Abfragen effizient zu sortieren Du übst Firebase Auth & Realtime Database Apps mit praktischem Code, den du direkt im Browser ausführst, und ein 24/7 KI-Tutor beantwortet deine Fragen während du die Lektion bearbeitest.

Brauche ich Erfahrung, um Firebase Auth & Realtime Database Apps zu starten?

Keine Vorkenntnisse erforderlich. Firebase Auth & Realtime Database Apps auf CoddyKit ist für Anfänger bis fortgeschrittene Lernende strukturiert, sodass du hier starten oder von Anfang an beginnen und in deinem eigenen Tempo voranschreiten kannst. Dies ist Lektion 2 von 4.

Wie lange dauert die Lektion „Daten filtern und sortieren“?

Die meisten CoddyKit-Lektionen dauern etwa 5–10 Minuten. Jede ist kompakt und interaktiv, sodass du stetig Fortschritte machst und genau dort weitermachst, wo du aufgehört hast – im Web und in der App.

Kann ich in dieser Firebase Auth & Realtime Database Apps-Lektion Code schreiben und ausführen?

Ja. Jede Firebase Auth & Realtime Database Apps-Lektion enthält einen integrierten Code-Editor, sodass du echten Code direkt in deinem Browser schreibst und ausführst und sofort KI-Feedback erhältst — ohne lokale Einrichtung erforderlich.

Alle Lektionen in diesem Kurs

Grundlegende Datenabfragen
Daten filtern und sortieren
Techniken zur Seitennummerierung
Abfragen für bessere Leistung indizieren

← Zurück zu Firebase Auth & Realtime Database Apps