Overview

...

The Query Builder is an unstructured window that allows a user to run preloaded SQL (Structured Query Language) statements against the production database. This feature is typically used to produce ad hoc reports at very short notice (faster than having us build a report for you). To learn more about how to use SQL, you can visit sites such as W³ Schools^{for an overview and examples of SQL.}

...

This window is not editable in the production database. To add queries, you must create them in the UAT environment and then ask us to promote them when you are ready to move them to production. This feature has the following advantages and limitations:

...

All queries are organized into groups. The Group Name is a dropdown containing a list of groups sorted by their names.

How to search for a Query by Group:

1. Double-click on the Query dropdown,

2. Select a group

3. Select a query

How to create a new Group:

1. Click the “+” button on the right of Query Group dropdown

2. Click ADD in the Query Type window

3. Enter the new query type name

4. Click OK

5. Click SAVE in the Query Type window.

How to Delete a Group:

1. Click the “+” button

2. Select a group from the list

3. Click DELETE in the Query Type window.

...

How to reassign a Query:

1. Open the query in the Query Builder window

2. Select another group from the Group Name dropdown

3. Click SAVE.

How to Create a Query

...

Unlike the other components, the Query Builder does not support paging (predefined page size and navigation between the pages using the Next and Back buttons). Specify the Page size (number of visible rows to preview) instead and click FILTER. There's no limit to the page size. To see how many records are populated, click the Total countCount button.

...

To export or print the results, position the cursor on the grid and right-click the mouse button.

...