Query Builder is designed to create query to pull out information from the database tables.
To open the screen, choose Reports > Designer/Label > Query Builder
Search Screen
Field |
Description/Activity |
Search Criteria |
|
Id |
Specify the Id of the query to be searched. |
Description |
Specify the Description of the query to be searched. |
Type |
Select Type value on which records to be searched. Possible values: •AllArea: Search all type of queries •Dashboard: Search queries where type is Dashboard. •Transaction Search: Search queries where type is Transaction Search. •Scheduler: Search queries where type is Scheduler. |
Search Results |
|
Id |
Displays the Id of the query. |
Description |
Displays the Description of the query. |
Setup Screen
Field |
Description/Activity |
Search Criteria |
|
Id |
Specify the Id of the query. |
Description |
Specify the Description of the query. |
Type |
Specify Type of the Query. Possible values: •AllArea •Dashboard •Transaction Search •Scheduler |
Designer Area |
|
Table List |
Displays the List of tables from iVend database. |
Designer Area |
Shows the selected tables. Tables can be dragged from the table list onto the Designer area. If multiple tables are selected then the tables must be joined. To specify a join on a table you can drag and drop a column of a table onto another table. |
Direct Query Text Box |
If users are comfortable writing the query directly then instead on selecting the table from the table list a query can be directly written in this area. |
Buttons |
|
Execute |
Click on this button to execute the query and see the results. |
Export to Excel |
Click on this button to export the results to an excel file. |
OK |
Saves the record in the database. |
Cancel |
This button does not save any changes and closes the screen. |
