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

1. Select the Export button to define the data that will appear when the query runs. A popup appears.

   

2. Configure the following settings:

   • Search: Use the Search function to quickly find a desired export.

     • Groups:

       • Library Exports: Select this box to display exports that have been configured within a Query Library.

       • Direct Exports: Select this box to display all available exports that are directly on the base from which the query was created and which the query has direct access to without joining to another table.

       • Extended Exports: Select this box to display exports that are available by joining out to other tables.

     • Exports: Select the Exports that should be included within the Query.

       • Select Select All to select all the exports within a group.

2. Select Save. The selected exports are added to the query.

Configuring exports

Configuring an export includes the following:

• Status: Make an Export Active or Inactive. Inactive exports will not be included in the results.

• Name: Alter the display name of the Export. The Export will be seen as the column in the list of results.

• Width: Set the width of an Export's column for fixed-width exports or to truncate a value to keep it under a certain length.

• Export Value: If the Export is a custom field, define the exact value to export.

• Format Type: Configure an appropriate format type. See the chart below for available format types.

• Null Value: Provide a value to appear when there is no value for a record.

Format Types

Selecting a Format Type precisely defines the format mask (i.e., the way it displays) for values exported in the query: 

Configuring Export Values

Custom Fields with prompts

If a custom field uses prompts, up to five alternative export values may be displayed in the results of a query.

Each prompt is configured with an alternative Export Value. For example, the export value may contain the institutional SIS code for that prompt.

When configuring the Entry Term field export within a query, a prompt's Export Value may be displayed in the results, rather than a prompt's Value.

When the query runs, the alternative Export Value will display in the results for that export column: 

⭐ Best Practice

Be consistent when adding export values.

• For example, if an export field needs to be added to a file that will export to an external system like an SIS, ensure that all associated prompts use the same Export Value configuration.

• That is, if the SIS code needed is stored as Export Value 3, then all associated prompts should have their respective SIS code stored as Export Value 3 as well.

Extended Values

A custom field that uses prompts may be configured with a Short Value. For example, a Major field that uses an associated prompt list.

✨ Tip

A school will sometimes add Short Values for academic program prompts which are known internally with shorter names or codes. The Short Value will be displayed in other areas of Slate, like within an application tab on the student record.

If Value is selected, a query export will return the Short Value if a short value exists for a prompt.

In order to override this behavior, select Extended Value. This will export the full value of a prompt rather than the Short Value.

The query will then return the full prompt value in the query results:

Fields that store multiple values

Configuration options will customize how values are sent. For example, a Slate record may have the following information stored in a Race field.

• American Indian or Alaska Native

• Asian

• White

In order to export all values in the query, configure the export to return All Field Values and add an optional Separator.

• Selecting All Field Values will return all the values stored in a field for a record.

• Define how multiple values are to be separated. Common separators include: , | ~ -

✨ Tip

The Separator setting can be left blank and values will not be separated.

The query results will display like this:

What's the order?

For ordered fields, the index value matches the order number. For unordered fields, values are ordered alphabetically.

Display One Value

Alternatively, just one precise value can be exported:

• Under All/One? select the Single Field Value at Selected Index option to return only one value.

• Choose which Index Number value should be exported (e.g., 1 will return the first value for the field, 2 will return the second value for the field).

The query results will then display like this:

Asian is the second value that is stored within the Race field for this record, and so would be returned when 2 is entered as the Index Number.

Display null values

A value may not exist in Slate for a particular record. When a value does not exist, the export column will be blank (NULL).

A query can be configured to export race information that looks like this:

A particular value can be included in an export even if a value does not exist.

For example, when exporting race information to an external system, an export value of "Unknown" can display when a record does not have a Race value.

Configure the export to include a Null Value setting.

The query results will then display like this: