0Pricing
Firebase Auth & Realtime Database Apps · Lección

Filtrado y ordenación de datos

Aprenda a filtrar datos según criterios específicos y ordenar los resultados eficazmente mediante consultas de Firebase.

Filtrado y ordenación de datos es una lección gratuita de Firebase Auth & Realtime Database Apps en CoddyKit. Esta es la lección 2 de 4. Puedes leer la lección completa abajo gratuitamente — luego la practicas en el navegador con un editor de código integrado y un tutor de IA 24/7. Forma parte de la ruta de aprendizaje de Firebase Auth & Realtime Database Apps, y tu progreso se sincroniza en la web y la app de CoddyKit. El curso de Firebase Auth & Realtime Database Apps incluye 4 lecciones en total.

Partes de esta lección aún no han sido traducidas y se muestran en inglés.

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.

Preguntas frecuentes

¿La lección «Filtrado y ordenación de datos» es gratis?

Sí — el texto completo de «Filtrado y ordenación de datos» es gratis para leer aquí en la web. Para practicarla de forma interactiva (editor de código integrado y tutor de IA 24/7) y desbloquear el resto del curso de Firebase Auth & Realtime Database Apps, actualiza a CoddyKit PRO. El curso de Firebase Auth & Realtime Database Apps incluye 4 lecciones en total.

¿Qué aprenderé en «Filtrado y ordenación de datos»?

Aprenda a filtrar datos según criterios específicos y ordenar los resultados eficazmente mediante consultas de Firebase. Practicas Firebase Auth & Realtime Database Apps con código real que ejecutas directamente en el navegador, y un tutor de IA 24/7 responde tus preguntas mientras trabajas en la lección.

¿Necesito experiencia previa para empezar Firebase Auth & Realtime Database Apps?

No se requiere experiencia previa. Firebase Auth & Realtime Database Apps en CoddyKit está estructurado para principiantes hasta estudiantes avanzados, así que puedes empezar aquí o desde el inicio y avanzar a tu ritmo. Esta es la lección 2 de 4.

¿Cuánto tiempo toma la lección «Filtrado y ordenación de datos»?

La mayoría de las lecciones de CoddyKit toman alrededor de 5–10 minutos. Cada una es compacta e interactiva, así que avanzas constantemente y retomas exactamente por donde dejaste en la web y la app.

¿Puedo escribir y ejecutar código en esta lección de Firebase Auth & Realtime Database Apps?

Sí. Cada lección de Firebase Auth & Realtime Database Apps incluye un editor de código integrado, así que escribes y ejecutas código real directamente en tu navegador y obtienes retroalimentación instantánea de IA — sin configuración local necesaria.

Todas las lecciones de este curso

  1. Consultas de datos básicas
  2. Filtrado y ordenación de datos
  3. Técnicas de paginación de datos
  4. Indexación de consultas para mejorar el rendimiento
← Volver a Firebase Auth & Realtime Database Apps