Components of Query Designer
Query Designer is made up of these forms:
Query Builder
Use this form to assemble the pieces of your query, to run the query,
and to display the results.
The Query Builder has these tabs:
- Query — Where you build the query.
- Collection — This is for advanced users. This
tab you to determine how to access the list of records from various
collections available in the database. You can apply more filters
on this tab to improve performance when finding the information that
you're retrieving from the database.
- Parameters — Enables you to add parameters which
you can use to further refine your queries.
- Preview — Displays a limited number of query results
so you can check that the query is returning the information that the query returns.
View Builder
Use this form to determine how to display your query results.
You can also use this form to determine how to group and, where necessary,
total the results.
The View Builder has these tabs:
- Data View — Where you build the view.
- Preview — Displays a limited number of query results.
Do that to check whether or not data displays in the correct format.
Query Results Viewer
Use this form to enable all users to run the queries that have been
created for them.
Query Designer Manager
Use this form to import or export queries as XML files.
ODBC Exposure
Use this form to add a query table to the database. You can
then use that table to pull data into a third-party reporting, spreadsheet,
or auditing tool.