Visual Query Builder in Dashboard Designer

Once you launch Infocaptor, you can click on the connect button.

In this example we are using the northwind sample database

Click on connect

Once connected it will open the Option wizard

Since there is no dashboard open, the “Build New Query” is disabled.

Click on the “New Blank Dashboard”

Enter some name for the dashboard “Northwind Dashboard”

Click OK

This Action immediately launches the Query Builder interface

Expand the node on the left

This displays a list of available tables

Double click on any table and it brings the table in the Query Builder window

You can now select columns and join then

To create joins, just drag the mouse on a column in the orders table. Once you see the join link appear you may release the mouse button. Now go to the second table and click on the column to which it needs to be joined.

Click on the SQL tab and you can see the SQL query that is automatically built for you

Now click on the “Create Table” button

This action creates a Qlet and places it in the dashboard

You can now right click on any column and create a drop down parameter

The parameter now automatically refreshes the qlet when you change the value

ShareThis

Read More