- 25 Apr 2024
- 1 minute read
- Print
- DarkLight
- PDF
Troubleshooting Queries
- Updated 25 Apr 2024
- 1 minute read
- Print
- DarkLight
- PDF
Identify the export/filter in question
Are there other filters/exports in use that affect the output?
Deactivate multiple query parts at once
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.
Check the underlying data
Does the data actually exist on the Student Record? Use the Person Reference ID filter available on the Person table in a Configurable Joins query 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?
Does the scope of the data match the scope of the filter/export?
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.
Are there any additional restrictions imposed by the query base?
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.