User Defined Queries

Providing your users with quick and powerful access to their data is something they will thank you for over and over again. Using a familiar Wizard type interface, your users will be guided to easily create and save their own queries.  Based on your configuration, they can then use those queries to view data in a browse, print a report, or process records for any output you specify.

The interface can be accessed through a set of query buttons or a drop down list control which displays a list of saved queries.

Quick Filter

The quick filter allows the end user to right click on a browse cell and quickly query the value under the mouse cursor.  The results and be joined with more complex queries saved by the main Query Wizard interface or stacked together with and/or joins to allow the end user to quickly drill down into the data they are searching for.

Query Wizard allows your end users to…

• Use a simple, intuitive interface to quickly create and save an unlimited number of Query definitions which may be applied to a browse, process, or report at any time.
• Drill down into data quickly and easily and conditionally join queries together to gain even more insight into their data.
• Advanced users can easily create complex queries right in the Wizard interface with up to four levels of nested groupings with a simple graphical display and interface.
• Pass the queries used on a browse to any process or report to create targeted and meaningful informational reports.
• Use the queries to pass a conditional filter to Report, Spreadsheet, and CrossTab Wizards with a common interface and highly targeted output.

Access Levels

With the optional Access Levels feature activated, your users can keep their saved queries separate from their coworkers in a shared environment.  There are features to allow for private, group, developer, and protected management of saved definitions.  The access feature easily ties in with any user login system.

Clarion Support

All versions of Clarion are supported from C55 through the latest C11 releases for both the Legacy and ABC template chains.  Multi-dll, standard .dll, and Single EXE targets are all supported directly and automatically based on your project settings.

Database Filtering Options

Query Wizard creates and applies standard Clarion VIEW filtering, but can also generate and apply SQL directly from user created queries through PROP:SQL.   The support for SQL is a simple switch in the Query Wizard Global Extension and can be applied to the entire application or overridden at the procedure level as needed.

Templates

To add the Query Wizard features to an application you simply add a new extension to your app. Then for each browse, report or process that will use the query you add the local extension and populate a control that calls Query Wizard. You can then customize the Query Wizard interface by answering the prompts in the template. These options will allow you to easily customize the list of available fields, add your own runtime variables or expressions, re-label field names and much more.

Translation Support

With a few template switches the Wizards will speak your language.  Using the Query Wizard builtin translation capabilities, you can access the predefined translation strings for the included languages.

• Croatian
• Dutch
• English
• French
• German
• Greek
• Norwegian
• Polish
• Spanish

If you don’t have Query Wizard, each product has simple embeds where you can add your translation pairs.  This is also convenient if you just want to change the wording on just a few select strings.

Dictionary Options

Using dictionary options can save time by allowing you to selectively include and/or exclude fields to Wizard field selection.  You can also customize override and expressions directly in the dictionary.  Careful usage of the dictionary option can speed up development if you have many procedures that use the same tables.

Access Control

If you need it, the Access Levels features of the Wizards will allow you to setup user and/or group access control for all the saved definitions.  You can also use this feature to create developer definitions that the user can have customized access to.  It is easy to interface with your own home grown security or any of the third-party security solutions out there.

Interface Graphics

The interface graphics can all be replaced with images of your choice and ship with 5 different color schemes that you can select to differentiate the different Wizard products.  This is useful when you add all the Wizard products to your application or when you just want the interface to more closely match your application look and feel.

The images are all stored in a simple .LIB file so are easily replaced with your own custom images.

Database Storage Addins

Each of the Wizard products by default use TPS files to store their saved definitions that the user can organize and recall as needed.  Sometimes TPS files are not a good fit for your application deployment environment. 

With an additional purchase you can direct the Wizards to store your end user’s saved definitions in MSSQL, ODBC, or Btrieve databases.  You must have a license or purchase the base product in addition to the Driver Addin.  The latest releases can be purchased in the Shop, and there are upgrades available at a discount as well for owners of previous versions.

• MSSQL
• ODBC
• Btrieve

Thin@ Addin

By purchasing the additional Thin@ Addin, you can easily enable your SAAS solution using Thin@.  The Wizards work as you would expect from the desktop release and there is no additional setup require by you except for installing the Thin@ Addin for each product you require.  The latest releases can be purchased in the Shop, and there are upgrades available at a discount as well for owners of previous versions.

• Thin@ Support