Troubleshooting Queries
  • 25 Apr 2024
  • 1 minute read
  • Dark
    Light
  • PDF

Troubleshooting Queries

  • Dark
    Light
  • PDF

Article Summary

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.

Activate_and_Deactivate_Multiple_Exports_at_Once.pngYou 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.


Was this article helpful?