Custom SQL queries

Custom queries are for advanced users who are familiar with using SQL for finding specific addresses in their database.

Custom queries are useful for queries not yet supported within RocketSales, e.g. joins across multiple tables.

Turning on

Choose Query from the Contacts tab.

SQL queries are a type of filtering. You'll know the SQL query filter is on when the numbers in the # column are shown in blue.

Running a query

1. Enter your query in the SQL query box. For database safety, only SELECT statements are allowed.
2. Click Run

Turning off

Click Query from the Contacts tab once again to turn off the SQL query feature.