Govern Query Tool (QT)

Overview

The Govern QueryTool is designed for performing searches on Govern data. It provides a user-friendly interface for creating and running SQL selection queries. You can easily add conditions or change existing ones on the fly. No knowledge of SQL is required.

By default, it is integrated with Govern OpenForms and can be launched from the Tools menu. It can be integrated with Govern for Windows. Alternatively, you can use it as a standalone application.

NOTE: The QueryTool is used for selection queries only to view information from the Govern database. It cannot be used for action queries to add, update, or delete information from a database.

With the Govern Query Tool, you can:

Run predefined queries or create new ones directly from the Govern application.
Change conditions or add new ones on the fly. Then, see the results immediately.
Create and save private queries for your own use or public queries that you can share with specific roles and users
Add conditions to refine the search
Add comparison or logical operators

User Interface

The Query Tool UI has the same general features as the Govern interface, for detaching, moving, and pinning the panes and other features in different locations. For details, see
https://kb.harrisgovern.com/101-std-fea-001.

Integration

Integrating the QueryTool with Govern for Windows

The Govern OpenForms QueryTool can be integrated with Govern for Windows and launched directly from the Applications or Tools menu.
You can then perform a Selection Query and load the results to the Govern tables: PC_EXTERNAL, NA_EXTERNAL, or PM_EXTERNAL.

For information on integrating the Query Tool with Govern for Windows, click on the
Integrating the Govern QueryTool with Govern for Windows

System Requirements

For the system requirements for this application and all applications in the Govern OpenForms product suite, see System Requirements.

Documentation

The reference guide for the Govern QueryTool describes how to configure you business models for use in the QueryTool, how to set user access permissions and restrictions, and how to create and share queries.

Govern QueryTool version 6.0

UPDATE! Govern QueryTool 6.0

GovernOpenForms 6.1 is not backward compatible with Govern for Windows. For information on Integrating earlier versions of the Govern Query Tool with Govern for Windows. For information on integrating the Govern Query Tool with Govern for Windows, see Windows Integration

Govern QueryTool version 5.1

Govern QueryTool 5.1

What’s New

Standard Help Feature implemented [v.6.0]
Security by Jurisdiction [v6.1] If security is enabled on the Jurisdiction User Validation table, queries can be filtered by jurisdiction. Then, users can view data only from jurisdictions to which they are granted security permissions.

Videos

Read More...Read Less...

The following video series provides an overview of the interface and key features.

Govern QueryTool UI Quick Tour

This video provides a quick tour of the QueryTool user interface showing the various components, the menus, and the key features.
QueryTool Quick Tour

Creating a Query

This video presents a short scenario showing how to create a query and add conditions.
Creating a Query

Running a Query

This video presents a short scenario showing how to run an existing query.
Running a Query

Sharing a Query

This video presents a short scenario showing how to share a query with other roles and users.
Sharing a Query

107-all-QT

(0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.