> For the complete documentation index, see [llms.txt](https://userguide.cryptoquant.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://userguide.cryptoquant.com/web3-analytics-tool/how-to-use-query-tool/3.-query-block-where.md).
# 3. Query Block - Where
## Where
”Where” section is used when you want to apply specific conditions to your query and view summary results for specific addresses, tokens, etc.
### How to use
1. Basic Options
1. First, select the column that you want to add the filter to. and specify the conditions to apply the filter.
2. To select columns, you can either select the desired column from the drop-down list that appears when you click the input box, or you can drag the column from the left pane and drop it in the where section.
[](https://downloads.intercomcdn.com/i/o/687213308/5952e9bb1237d871f1945301/where1.png)
3. Once a column has been added, you can select a filter from the list of Basic Filters. This list offers a range of basic filter options, including Greater than, Equal to, In, Is empty, Not empty, Contains, and Between.
[](https://downloads.intercomcdn.com/i/o/687213342/3fd77860e149a101fec3440f/where2.png)
4. Finally, the parameters are entered to complete the conditional expression. The number of parameters required depends on the selected filter, ranging from 0 to 2. Once all parameters are entered, the "where" clause is completed.
[](https://downloads.intercomcdn.com/i/o/687213378/dbf49ce8e0d9cf42ea22cd26/where3.png)
2. Adding another Where
1. Additionally, you can add another condition by either clicking the "+where" button to add multiple filters, or by dragging another column to the "where" section, which will automatically create another filter.
[](https://downloads.intercomcdn.com/i/o/687213445/67720da365576c398ae2a81b/where5.png)
2. You can then choose between using an AND or OR operator for the filters.
3. Custom expression
1. If you want to use more complex filters, you can click on "Custom expression" at the bottom of the drop-down, and an input field will appear. Here, you can apply filters based on multiple columns or the results of applying arithmetic operations to columns. All queries that are available in BigQuery SQL can be used in this field.
[](https://downloads.intercomcdn.com/i/o/687213537/7e7c11055182e74c7f65f62f/where6.png)
##
## Filter with Metadata
When applying filters, not only can you use data from the original table, but you can also use metadata information. For example, you can retrieve labeling information for a particular address from metadata and use it in your filter conditions.
### How to use
1. Select the column you want to apply the filter to, then choose "Filter with Metadata" from the condition dropdown to utilize both the data and metadata information in the original table.
[](https://downloads.intercomcdn.com/i/o/687213021/f8ce941ce06e7c175b75be42/where7.png)
2. When you select "Filter with Metadata" in the condition drop-down, an input field will appear that allows you to choose which metadata field to match with, following the "matching with" keyword.
[](https://downloads.intercomcdn.com/i/o/687212905/827885bc36b8c7fc4dcc9b88/where8.png)
For example, if the column you want to filter is related to Ethereum addresses, select 'Ethereum Address' in the metadata.
3. After selecting the matching field, you can enter the filter condition. For example, if you want to filter by the label name of an address, select 'Address Name' and enter the specific condition. For instance, you can enter a condition such as 'Address Name contains Binance'.
[](https://downloads.intercomcdn.com/i/o/687212765/58edc2ed93699204ab443431/where10.png)
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://userguide.cryptoquant.com/web3-analytics-tool/how-to-use-query-tool/3.-query-block-where.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.