Creating an instance summary table
Table objects are often attached to an instance table to provide a summary view of the instances.
To create a summary table for an instance, you add a table object to a dashboard and attach its valueTable property to an instance table. When you define the attachment, you can select the variables to be displayed; these will be the columns of the table. You can also specify a filter to show only a subset of instances.
Note that, by default, users are authorized to view only those dashboards that they created. Regardless of filter settings, users will not be able to see instances they did not create.
To create a instance summary table, create a new dashboard and perform the following steps
1. From the Tables tab in the Object Palette, select the Table object and add it to the dashboard canvas.
2. In the Object Properties panel, double-click the valueTable property.
The Attach to Apama dialog appears. Attach the table object's valueTable property to an instance table.
3. Select the autoResizeFlag property and enable it by clicking the check box in the Property Value column.
4. Resize the table such that all columns are visible. (You resize the table by selecting it and dragging the handles.)
The table now displays all the input and output variables of all instances of the specified instance, as well as the special fields Dashboard Builder adds, including apama.timestamp which indicates the time the instance last changed.
Often, you will not want to display all the variables or the special fields in a summary table. The steps that follow show how to specify the variables to be displayed.
5. Double-click the valueTable property to display the Attach to Apama dialog.
By default the display variables field is set to the wildcard “*” indicating that all the variables are to be displayed. Next to the field is a button labeled “…” that provides access to the Select Columns dialog.
6. Click on the “…” button to display the Select Columns dialog.
7. In the Select Columns dialog select and order the columns.
8. Click OK in the Select Columns dialog and OK in the Attach to Apama dialog.
The table object will now display only those columns you selected.
By default a table will display a maximum of 100 rows. If a dashboard needs to show more than 100 instances, change the value of the maxNumberOfRows property. The maximum value for this property is 131072.
By default a table is unsorted. If you want a table to have a default sort order, set the sortColumnName property to the name of the variable to sort by, such as Price.