After you’ve created forms, events, applications, and source formats to bring data into your student records, you’ll need to export it to send mailings and interact with your students. The query builder is a powerful tool that provides self-service access to information on the student record. You may, of course, occasionally experience difficulty identifying the correct records or data and the following steps can you help you resolve these difficulties.
Are there other filters/exports in use that affect the output?
Winter Wonder 2021: Deactivate multiple query parts at once!
Turn them all off with a click! Exports, filters, sorts, and joins can now be activated or deactivated in bulk.
Ctrl+click an export to select it and as many others of the same kind as you want, then click the Deactivate icon at the right and confirm.
You can also use Ctrl+Shift+click to highlight every export, filter, sort or join in a sequence.
- Does the data actually exist on the Student Record? Use the Slate ID filter available in the Slate Template Library to identify a specific record you know has the appropriate data to help streamline the troubleshooting process.
- Do the appropriate export values exist? If you are selecting export values, do the associated prompts all have appropriate export values?
Have any of your users recently changed the prompt list, field ID, or field scope? These changes can break existing exports/filters and is noticeable when only some of your records export data but others do not.
The most common example is a Departmental Applications query base where a user's permissions affect which applications they are able to query.
Slate limits all query rows to 64KB.
Are there existing exports/filters to accomplish the goal? It may be necessary to add a filter more than once to your query or use several filters to accomplish your goal.