Building Queries

Prev Next
  • Updated Sep 29, 2026
  • Published on Nov 20, 2023
A query returns exports—data points akin to columns in a spreadsheet—from records that meet your filter criteria. Creating a query Go to Queries / Reports. There are two types of queries you can create from this page: New query Creates a sav...
  • Updated Mar 4, 2026
  • Published on Nov 20, 2023
Query exports allow a user to extract data from Slate and display it in a manner that is appropriate for the end user. This may be used in queries, reports, merge fields and more. Adding exports Select the Export button to define the data th...
  • Updated Mar 9, 2026
  • Published on Nov 20, 2023
The Slate Template Library (STL) offered a list of common exports and filters that many clients used to query on data. Those exports and filters, however, are not accessible in Configurable Joins. We've rebuilt many of these exports and filters in...
  • Updated Apr 2, 2026
  • Published on Nov 20, 2023
Use these pre-built, person-scoped exports and filters to handle common use cases without building complex Configurable Joins queries from scratch. Import them into your database as query libraries using Suitcase . Import the query library Copy...
  • Updated Apr 2, 2026
  • Published on Nov 20, 2023
A subquery filter looks across the 'many' of the one-to-many relationships in Slate to determine which records to return in a query. Several aggregate functions can be used to filter records based on values on other query bases, including: Exists...
  • Updated Oct 22, 2026
  • Published on Nov 20, 2023
A subquery is an inner, nested query within an enclosing query. A subquery export —as opposed to a subquery filter or a subquery join—is a type of subquery that returns export data. Like regular exports, subquery exports let you define a co...
  • Updated Oct 23, 2026
  • Published on Nov 20, 2023
Data, such as person records, fields, and mailings, are organized and stored in tables . You can think of a table as a single page in a spreadsheet, with each data object taking up a row. A collection of these tables form a Relational Database , ...
  • Updated Nov 17, 2026
  • Published on Nov 21, 2023
When choosing the Configurable Joins query base for your query or report part, asking yourself which data you’re hoping to display or aggregate helps you determine the base best suited for your purposes. What is a query base? The base for a que...
  • Updated Jun 19, 2026
  • Published on Nov 20, 2023
When you create a query or select Edit on an existing query’s overview page, you’ll find the following settings: Name Give the query a name. This name will only be visible administratively. The name may be changed at any time if necessa...
  • Updated Aug 28, 2026
  • Published on Jun 19, 2026
When you create a query and select Edit Query → Edit Properties , you’ll find the following settings: Limit Rows Restrict the number of returned results by configuring a row limit. This setting is typically used when configuring a query for: ...
  • Published on Jun 19, 2026
When you create a query and select Edit Query → Schedule Export, you’ll find the following settings. 📖 See Scheduling Data Exports for more details. Status Determine whether or not the export should automatically be based on the schedule ...
  • Updated Mar 11, 2026
  • Published on Nov 21, 2023
The following settings are configurable when you select Edit on a query export. Status Active: will export data when the query runs.  Inactivate : will temporarily disable the export without being deleted. Name The name of the ...
  • Updated Aug 26, 2026
  • Published on Nov 20, 2023
In a query , after you select Run Query , you’ll find an Output setting that provides options in two categories: Export destinations: The various places in Slate to which you can send your query results and the formats in which you can expo...
  • Updated Sep 18, 2026
  • Published on Jun 13, 2025
When creating a form response-scoped query, or joining to Form Response in any query, you’ll be prompted to choose between querying responses for all forms and events or a specific form, event, or template . Depending upon the option you choose, ...
  • Published on Jul 1, 2026
🏔️ Summit 2026 Feature Use Slate AI to sort, filter, reshape, and summarize query results after a query runs. Slate AI Dynamic Queries let users ask Slate AI to work with query results without rebuilding the underlying query. Use natural-la...
  • Published on Jul 1, 2026
🏔️ Summit 2026 Feature Manage exports, filters, and joins faster in embedded query builder contexts. In express and embedded query builders, including subqueries and the query builders used in rules and form conditions, you’ll now find contro...
  • Updated Jun 24, 2026
🏔️ Summit 2026 Feature Use Configurable Joins query parts in eligible legacy queries so you can modernize exports and filters without rebuilding the entire query first. 🏗️ Provisional document This feature is pending release, and this...
Still looking for what you need?