0Pricing
Firebase Auth & Realtime Database Apps · Aula

Filtragem e ordenação de dados

Aprenda a filtrar dados com base em critérios específicos e ordenar os resultados com eficiência usando consultas do Firebase.

Filtragem e ordenação de dados é uma aula grátis de Firebase Auth & Realtime Database Apps no CoddyKit. Esta é a aula 2 de 4. Você pode ler a aula completa abaixo gratuitamente — depois pratica ao vivo no navegador com um editor de código integrado e um tutor de IA 24/7. Faz parte do caminho de aprendizado de Firebase Auth & Realtime Database Apps, e seu progresso é sincronizado entre a web e o app CoddyKit. O curso de Firebase Auth & Realtime Database Apps inclui 4 aulas no total.

Partes desta aula ainda não foram traduzidas e aparecem em 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.

Perguntas Frequentes

A aula “Filtragem e ordenação de dados” é grátis?

Sim — o texto completo de “Filtragem e ordenação de dados” é grátis para ler aqui na web. Para praticá-la interativamente (um editor de código integrado e um tutor de IA 24/7) e desbloquear o restante do curso de Firebase Auth & Realtime Database Apps, atualize para CoddyKit PRO. O curso de Firebase Auth & Realtime Database Apps inclui 4 aulas no total.

O que vou aprender em “Filtragem e ordenação de dados”?

Aprenda a filtrar dados com base em critérios específicos e ordenar os resultados com eficiência usando consultas do Firebase. Você pratica Firebase Auth & Realtime Database Apps com código prático que executa diretamente no navegador, e um tutor de IA 24/7 responde suas dúvidas enquanto trabalha na aula.

Preciso ter experiência prévia para começar Firebase Auth & Realtime Database Apps?

Nenhuma experiência prévia é necessária. Firebase Auth & Realtime Database Apps no CoddyKit é estruturado para alunos iniciantes até avançados, então você pode começar aqui ou desde o início e aprender no seu ritmo. Esta é a aula 2 de 4.

Quanto tempo leva a aula “Filtragem e ordenação de dados”?

A maioria das aulas CoddyKit leva cerca de 5–10 minutos. Cada uma é compacta e interativa, então você faz progresso constante e retoma exatamente de onde parou entre web e app.

Posso escrever e executar código nesta aula de Firebase Auth & Realtime Database Apps?

Sim. Cada aula de Firebase Auth & Realtime Database Apps inclui um editor de código integrado, então você escreve e executa código real direto no navegador e recebe feedback de IA instantaneamente — nenhuma configuração local necessária.

Todas as aulas deste curso

  1. Consultas básicas de dados
  2. Filtragem e ordenação de dados
  3. Técnicas de paginação de dados
  4. Indexação de Consultas para Melhor Desempenho
← Voltar para Firebase Auth & Realtime Database Apps