Query Tool
The Deacom Query Tool is a read-only SQL based tool that can access all or a majority of the data in the system (some tables such as the user table, dxuser, are restricted in lower versions). Any SQL query can be written and run using this tool. The results of a query can be exported to Excel for further processing if necessary. As with any SQL tool, Deacom table and field names are required when using this tool. To locate table and field names to use in queries, use the Data Dictionary located under System > Data Dictionary. The Data Dictionary can also be accessed by right clicking a field in the results grid and provides field linkages that can be used for joining tables.
Additional notes regarding this tool include:
- User access to the Query Tool is controlled by the "System -- Query Tool" security permission.
- Queries can be published as Favorites and Previews.
- The query tool can only access the three Deacom databases for security reasons. Each time a query is run in Deacom, a temporary user is created in order to run the query. This temporary user is limited to the Deacom databases and any public folders. If an external database needs to be accessed via a Deacom query, go to the database properties, click on the Permissions tab, select the "public" user, and in the Grant column, put a checkmark next to the "Authenticate", "Control", "Execute", "Select", "Subscribe Query Notifications", and "View Database Definition" options.
System Navigation
System > Query Tool
Query Tool form
|
Button |
Description |
|---|---|
|
Open |
Allows the user to select a previously saved query to work on. |
|
Save |
Allows the user to name the query for future use. |
|
View |
Runs the query and displays and results. |
|
Clear |
Resets the form to its original values. |
|
Open View |
Opens a previously saved view. |
|
Save as View |
Allows the user to save the current view. |
|
Delete View |
Deletes a previously saved view. |