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
  • Overview
  • Implementation
  • Testing
  1. REST
  2. Select Method
  3. Filter

Groups

PreviousDynamic FilteringNextExists clause

Last updated 4 months ago

Overview

Grouping conditions in filters enables you to combine multiple criteria with logical operators like AND and OR, as well as to nest conditions for more complex filtering scenarios. This is essential for building queries that require precise control over how filters are applied.

Implementation

In the filter pop up, click on the "group" button

Now select column and condition you want, basically we are declaring a filter rule here again

Now click on "rule" button inside the group, and repeat the same process to add another rule

Now you can choose if you want to use the AND or OR operation by clicking on the corresponding button (Here we select AND)

Operator

Description

and

All conditions must be true.

or

At least one condition is true.

We can also add sub groups under a main group by clicking on the "group" button inside the group you want to add to

Inside this sub group we can again add rules in the same manner

And the AND/OR options above the group help it decide which operation it is compared with against the rest.

Now click the "Save" button at the bottom of the page

Testing

Copy the URL Endpoint from the top right of REST API page

Open Postman and then paste the endpoint in the input bar and hit send to place the request

You should get a response which follows our filtering criteria as shown below