KNOWLEDGE BASE
Glossary
Login
Contents
x
Getting Started
Applications
Branding
Deliver
Events & Interviews
Fields and Prompts
Forms
Giving
Importing & Exporting
Inbox
Liquid Markup
Payments
Portals
Productivity Tools
Queries
Records
Reports & Analytics
Rules & Automation
Security & Privacy
Slate AI
Slate.org
Users & Permissions
News & Information
Powered by
Query (Legacy Articles)
9 Articles
in this category
Share
Print
Share
Dark
Light
Contents
Query (Legacy Articles)
9 Articles
in this category
Share
Dark
Light
Adding and Configuring Filters
Query Filters allow users to narrow down the results of a query. Add a filter Click or drag the Filter button to add a filter that will restrict the records included in the query. If you're using a Local or Slate Template Library query, it wi...
Updated : 21 Nov 2023
Local and Slate Template Library Query Bases (Legacy)
Important! Configurable Joins Query Bases All new queries should be built using Configurable Joins. To get started with querying with configurable joins, refer to: Introduction to Queries Transitioning to Configurable Joins Commonly...
Updated : 21 Nov 2023
Curating the Query Exports/Filters Tool (Legacy)
Important! Configurable Joins Exports & Filters All new queries should be built using Configurable Joins. To get started with querying with configurable joins, refer to: Introduction to Queries Transitioning to Configurable Joins ...
Updated : 21 Nov 2023
The Slate Template Library (Legacy)
Important! Configurable Joins Exports & Filters All new queries should be built using Configurable Joins. To get started with querying with configurable joins, refer to: Introduction to Queries Transitioning to Configurable Joins ...
Updated : 21 Nov 2023
Direct SQL Access
Slate supports direct, native SQL Server connections that can be used by any client that supports connections to a SQL Server. The connections provide a read-only interface to your Slate database. These credentials can be directly provisioned in Sla...
Updated : 17 Jun 2024
Custom SQL Hybrid Queries
The query system supports hybrid queries that pair the advanced capabilities of custom SQL with the intuitive, straightforward query system filters that can be edited by any end-user. These hybrid queries enable cross-tab reports and other advanced ...
Updated : 21 Nov 2023
Slate user-defined SQL functions
Slate provides several functions defined in the SQL server database that may be used as macros to make SQL code simpler and cleaner. The following is a partial listing of some commonly used functions. Table-valued functions The...
Updated : 21 Nov 2023
Query Base (Legacy) Settings
Insert / Edit Query Bases
Updated : 23 Apr 2024
Exporting Materials to an External System (Legacy)
Slate supports exporting documents to an external document management system (such as OnBase, ImageNow, or Docfinity). The documents can be packaged in one of three ways: in a zip archive with an index file, in a zip archive with the index keys incl...
Updated : 25 Apr 2024