Qlet Properties

Enter any user friendly name for this Query Portlet. This will appear as the title of the portlet on the dashboard

 

Select the connection that you established using the connection wizard

 

This is a very useful property. You can control the number of rows returned by the SQL query. For e.g, if your Query is returning Sales in descending order by Region and if it is returning say 1000 rows from your database then by specifying the Max Rows=100 shows the "Top 100 region by sales"

 

This property instructs the dashboard to treat the portlet in a certain way as described below

 

Run On Start = Y, this setting always fetches the data when the dashboard is launched

 

Run On Start = N, this setting puts the portlet in hibernate mode i.e. the data is not fetched until the user manually refreshes the portlet

 

When you do a complete export of the Dashboard (PDF or HTML), this property controls the placement of the portlet in the final output. If it is set to 'N' then the portlet is excluded from the pdf or html output.

 

You can include/exclude this portlet from the Auto-refresh mode. For e.g. if you have 4 portlets in your dashboard and you need only 3 portlets to auto-refresh every 30 secs or say every 5 minutes then you can set the one portlet to 'N' and remaining 3 portlets to 'Y' for this property.

 

This is a virtual grouping of portlets on the tree browser. All the portlets (qlets and glets) having the same Tree group value appear as children under the same parent node.

 

InfoCaptor uses the Java Dateformat as described here http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

 

Use the following e.g. for different number formats

http://java.sun.com/docs/books/tutorial/i18n/format/decimalFormat.html

 

This is an internal unique identifier of the Qlet within the dashboard. It is automatically assigned when you create a new Qlet

 

All of these properties "Row 0 Color", "Row 1 Color" .... etc help to create visual seperation of rows. For e.g you can create different colors and fonts for alternating rows. It is not just limited to alternate rows.

 

The property "Row 0 Color Interval" allows to change the gap between alternating rows. Just manipulate this value and see the different combination it creates. Check these examples

 

If you need to do advanced banding such as value based rather than by fixed rows then check this approach of value based highlighting and banding