--- title: "Query Search" url: https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/query-search/ description: "Catalyst NoSQL is a fully-managed, powerful database that provides you with a non-relational, non-SQL means of data storage. Create, manage, and query data in NoSQL tables with ease, and perform CRUD operations in Java, Node.js, and Python." last_updated: 2026-08-28T06:26:16Z service: Cloud Scale type: general --- # Query Search in NoSQL ### Overview Catalyst enables you to perform query searches to read table data in NoSQL from the console, the server-side SDK in [Java](https://docs.catalyst.zoho.com/en/sdk/java/v1/cloud-scale/nosql/get-table-metadata/), [Node.js](https://docs.catalyst.zoho.com/en/sdk/nodejs/v2/cloud-scale/nosql/get-component-instance/), or [Python](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/nosql/get-component-instance/), or through [API](https://docs.catalyst.zoho.com/en/api/code-reference/cloud-scale/nosql/insert-item/#InsertNewItem). The Data section in the console includes a query section where you can search for data and the results will be displayed in it. A query operation in NoSQL is scoped to a partition of the data storage. This means that you can search within a partition for an item based on the partition key alone, in case the table is configured with a simple primary key. If the table is configured with a composite primary key, the search occurs using the combination of a primary key and sort key. You can also utilize additional sort keys that you configured for a table with the combination of the partition key to execute query searches. Refer [to this page](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) to learn about table keys. You can base a query search off a table or off an index of the table. This will inform Catalyst to look for the appropriate partition and provision the appropriate primary keys for the search. ### Supported Operators Catalyst supports several operators that you can use to execute queries. These operators can only be used with the primary sort key and additional sort keys. Depending upon the data type of the sort keys, the supported operators vary. > **Note:** You can only use the "EQUALS" operator with the partition key. The operators listed below can only be used with the sort key of an index, or the sort key and additional sort keys of a table.
Data Type of the Sort Key Supported Operators
String Equals, Not Equals, Between, Not Between, Greater Than, Lesser Than, Greater Than or Equal To, Lesser Than or Equal To
Numeric Equals, Not Equals, Between, Not Between, Begins With, Ends With, Greater Than, Lesser Than, Greater Than or Equal To, Lesser Than or Equal To, Contains, Not Contains, In, Not In
> **Note:** All the supported operators are available through SDK and API operations, while some of these supported operators are not available in the console search. Refer to the respective SDK and API help documentation for details. ### Execute a Query Search You can execute a query search from the Catalyst console to read data from a NoSQL table in the following manner: 1. Navigate to the *Data* section of the table in NoSQL. ![nosql_data_query](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_query_1.webp) 2. You can select the table name or any one of the indexes to perform the search in, from the drop-down on top. Catalyst will list the table and all indexes. ![nosql_data_query](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_query_2.webp) 3. If the table is configured with the simple primary key, enter a value for the partition key to search. The data type configured for the partition key will be automatically shown. If the table is configured with the composite primary key, enter the value for the partition key, then select the required operator from the list for the sort key and enter a value to search. You can choose the main sort key or any one of the additional sort keys, if configured. The data type configured for the sort key will be automatically shown. ![nosql_data_query](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_query_3.webp) > **Note:** You can only use the ["EQUALS" operator](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/query-search/#supported-operators) with the partition key. Depending on the data type of the primary or additional sort key, appropriate operators will be available for selection. 4. You can also check the "Enable this to search using ascending sort" box to list the search results in the ascending order. Descending sort will be used by default. If no sort key is configured for the table or the index you select, the sorting order of retrieved data is based on the partition key of the table. 5. After you configure the query parameters, click **Search**. The query results will be displayed in this section. If no results are found, Catalyst will display an appropriate message. ![nosql_data_query](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_query_4.webp) You can use the filter option to choose the columns to be displayed, or view the data as JSON, as discussed in the [previous section](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/add-manage-data/#add-data-in-a-table).