How to pass GET parameter values to Dashboard SQL – Drill down from external app

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

It is possible to pass URL parameters to any SQL widget within the Dashboard. This is useful for drilling from one dashboard widget to a different dashboard. This is also useful when you are drilling from a portal or third party application into InfoCaptor Dashboard.

NOTE: when you drill from external application, the dashboard needs to be public so it can be accessed just like any HTML page

Consider the following Grid with a simple SQL

Image

 

Now the SQL is a simple select * from hr_data

We will now make a parameter that can be passed as HTTP GET variable

Image

 

We added a where condition with http_location as the variable.

As you see the Grid does not show any records.

Save the dashboard and then click on ‘View this Page’

Image

 

You can now see the full dashboard URL

Image

 

At the end of the URL, type in the http_location=Chicago

Image

 

So now, you can change the location and the dashboard will respond accordingly. Here are some different values

Image

 

This demonstrates how to pass parameter values and drill down from External application/portal into Infocaptor dashboard.

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH