Exists clause

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