Visual Query Builder | Excel like operations… and the list goes on

This release has some major features and enhancements. The very best enhancement is a Visual Query Builder within InfoCaptor. You can now connect to any database and need not worry about knowing SQL to build dashboards. Just launch the Query builder and visually add tables and join them.

The second best enhancement is the ability to change the dataset that you get from your SQL query. You can use excel like cell,row or column operations to derive totally new data set.

Excel like operations

• Add rows
• Add columns
• Add cells
• Add blank rows
• Add blank columns

Transpose

• You can easily Pivot your data with the use of the transpose function

Grand Totals

• Add grand total for all numeric columns
• Add grand total for just single column
• Custom position for the total label
• custom name for the total label

Sub Totals

• Add subtotals on a column

Other enhancements

• Disable scrollbar
• provide update sql in javascript
• custom size and location of the dashboard browser
• Default date values for the date parameter. You can now use MONTH_BEGIN, MONTH_END, CURRENT
• Default null value for field type parameters

ShareThis

Read More