In this article we will discuss a scenario and how to accomplish it within the dashboard.
Let say you have two databases. Both databases have similar tables and you need to display the difference in the number of rows from these two tables.
InfoCaptor allows you to connect to multiple databases and display information on the same dashboard page. But in this situation we are required to create two distinct queries from two seperate databases and do calculation on the returned values.
This can be accomplished as illustrated below
Create first parameter with the total row count from 1st database table
Create second parameter with row count from second database table
Now create a Qlet that will do a difference between the two parameters
Right click on the text editor, will show the parameter list. Select the parameter Display value, remove the single quotes and the comments and then select the second parameter display value.
Once you select the p32 Get Display the Qlet text editor shows as below
Remove the single quotes and the comment section as shown below
Add a minus sign after the above string and then select the second parameter display value
Thats it - you get a Qlet that represents the difference of row counts between two seperate databases.
Now how about applying some conditional formatting to the Qlet
and then enter the following script
if (numericValue < 0 )
else if (numericValue >0 && numericValue <100)
else if (numericValue >100 )
Alternatively you could create a meter chart with the same query