The following table provides a quick reference to the Custom Query Ribbon and its functions.
Excel 2007 or Later
Icon
Description/Functionality
Download Form
A form to enter the Query Set for downloading records to Excel. Here the user can also indicate if they want to print parent information, whether they need to print column headers or use existing ones and, if needed, what filters they would like to use to limit the records to download.
Download from Sheet
When the headers are already printed on the spreadsheet the user can position their cursor right below them and click on this option to download records. The user will just need to pick the Query Set and then click the Download button.
Print Column Headers
Before downloading records directly from the sheet, the user needs to click on the Print Column Headers option. Here they will also select the row where the columns will be printed to.
Manage Queries
This option will give access to the Manage Query window where the user can create, modify, and delete SQL queries and responsibility access to query sets.
Load from File
This option will import xml query set data contained in selected worksheet cells into the instance the user is connected to. This feature is useful when writing custom Query Sets in one instance and then needing to copy these across to other instances.
To achieve this simply use the ‘Export Queries’ feature in the Custom Query ‘Edit Queries Using Form’ to copy the xml definitions into your current worksheet.
Then login to a different instance, select the cells containing the downloaded query sets and click the ‘Load From File’ button to import them into the current instance.
