Find data with filters

Filters are a foundational way to find data in any database. They are best for matching an exact value or range of values, such as finding a user by their user ID.

In Hyper-Converged Database (HCD), you can use filters alone or with sorting.

Find data with the Data API

If you’re new to the Data API, try the quickstart for collections or the quickstart for tables for a demo of some common operations.

With the Data API, you use filter and sort clauses to find data in collections and tables.

Any Data API command that involves finding data accepts one or both of these clauses.

  • Collections

  • Tables

For examples of filter and sort clauses in specific Data API commands, see the reference for the command that you want to run:

For general information about filter operators and sort clauses, see the following:

For examples of filter and sort clauses in specific Data API commands, see the reference for the command that you want to run:

For general information about filter operators and sort clauses, see the following:

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2025 DataStax | Privacy policy | Terms of use | Manage Privacy Choices

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com