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
  • How to Use EXISTS in QueryDeck
  • Testing
  1. REST
  2. Select Method
  3. Filter

Exists clause

PreviousGroupsNextPagination

Last updated 4 months ago

The EXISTS clause in QueryDeck allows you to filter rows based on the existence of records in a related table or subquery. It is particularly useful for evaluating whether a specific condition is true for one or more records in a related dataset.

How to Use EXISTS in QueryDeck

  1. Choose the EXISTS Operator on the filtering pop up

  1. Select a relationship to filter on.

  1. Save the changes

Testing

Copy the URL endpoint from the top right corner

Now open postman and paste the link in the URL input bar

Hit send to place the request

Here is an example response of what we should get