Filter

Filtering

Filters allow you to refine your query results by including only rows that meet specific criteria.

Adding Filters in QueryDeck

Choose the filter button in the left side pane

Filters can be added by specifying conditions in the where clause of your query by adding the required operator and value in the pop which appears

There are different operators you can filter based upon in Querydeck

Operator	Description

=	Checks if the value is equal to the specified value.

!=	Checks if the value is not equal to the specified value.

>	Checks if the value is greater than the specified value.

<	Checks if the value is less than the specified value.

>=	Checks if the value is greater than or equal to the specified value.

<=	Checks if the value is less than or equal to the specified value.

IS NULL	Checks if the value is null.

IS NOT NULL	Checks if the value is not null.

Copy the endpoint in the top right corner by clicking on it

Save the endpoint

---

Now open postman and past the url and hit send to test the endpoint

This is the response we get,