Querydeck Docs
  • 👋Welcome to Query Deck
  • Getting Started
    • 😃Get Started With QueryDeck
      • Quickstart With QueryDeck
    • How It Works?
  • REST
    • Select Method
      • Joins
      • Sorting
        • Ascending/ Descending ordering
        • Dynamic Sorting
      • Filter
        • Dynamic Filtering
        • Groups
        • Exists clause
      • Pagination
        • Offset
        • Limit
    • Insert/Upsert Method
      • Nested Inserts (Joins)
      • Conflicting Columns
    • Update Method
      • Filters
    • Delete Method
    • Authentication
    • Authorization
    • Select by Id
  • GraphQL
    • Introduction to GraphQL in QueryDeck
    • Enabling GraphQL for Columns in QueryDeck
  • Testing Endpoints
Powered by GitBook
On this page
  1. REST
  2. Select Method

Filter

PreviousDynamic SortingNextDynamic Filtering

Last updated 4 months ago

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,