<dvt:pivotTable>

dvt:pivotTable pivotTable pivot table

UIComponent class: oracle.adf.view.faces.bi.component.pivotTable.UIPivotTable
Component type: oracle.dss.adf.pivotTable.PivotTable

The Pivot Table supports the display of multiple nested attributes on a row and column header. In addition, the Pivot Table supports the ability to dynamically change the layout of the attributes displayed in the row or column headers via drag and drop pivoting.

Pivot Table Features

Pivot Table Model

The Pivot Table component uses a model to display and interact with data. The specific model class to use is oracle.adf.view.faces.bi.model.pivotTable.PivotTableModel. When linking a Pivot Table and a Graph to the same data is required, the Pivot Table model can be an instance of oracle.adf.view.faces.bi.model.DataModel.

Sizing

The inlineStyle attribute can be used to specify a Pivot Table's width and height. For example, inlineStyle="width:600px;height:400px" or inlineStyle="width:100%;height:400px".

Pivot Table supports auto-sizing, which can be used by setting pivot table's attribute sizing="auto". When auto-sizing is set, the height of the pivot table is determined by the size of the content that is being displayed by the pivot table. If the content is smaller than the default size of the pivot table, then the pivot table will shrink. If the content is larger than the default size of the pivot table, the content will grow and pivot table will display scrollbars as needed.
Please note that when sizing="auto", the pivot table's frame will initially be displayed with the default size of the pivot table ( using the width/height CSS attributes ) and then the pivot table's frame will readjust to fit its contents. This can cause the layout of the page displaying the pivot table to change after the page is initially displayed.

Customizing Cell Content

In order to customize header cell content, set HeaderFormat attributes. For customizing data cell content, use DataFormat. HeaderFormat/DataFormat attributes return instances of oracle.dss.adf.view.faces.bi.component.pivotTable.CellFormat. CellFormat instances allow specification of the following:

• a converter, javax.faces.convert.Converter, which is used to perform number/date/text formatting of a cell raw value
• a CSS style, which is used to change the CSS style of a cell
• a CSS text style, which is used to change the CSS style of a cell's text
• a new raw value, which is used to change the cell's underlying value that was returned from the data model

For more detailed description, refer to <dvt:dataCell> component guide

Selection

Selection allows a user to select one or more cells. Pivot table has three different types of selection, i.e. row header selection set, column header selection set, and data selection set. Only one type of selection can be made in pivot table at any one time. An application can implement some features, for example, display a customized content for a context menu, based on the current selected cells.

The code example below shows how to get the currently selected header cells.

       
            UIPivotTable pt = getPivotTable();
            if (pt == null)
                    return null;
            HeaderCellSelectionSet headerCells = null;
            if (pt.getSelection().getColumnHeaderCells().size() > 0) {
                headerCells = pt.getSelection().getColumnHeaderCells();
            } else if (pt.getSelection().getRowHeaderCells().size() > 0) {
                headerCells = pt.getSelection().getRowHeaderCells();
            }
       
       

Drill

Drill operation is used to hide or unhide hierarchy of the data within pivot table. It is supported when the underlying data source allows this operation. A drill listener will be notified after a drill event is successfully performed. drillEnabled attribute specifies whether drilling is enabled.

Pivot

Pivot operation can be peformed for each data attribute, and it will change the data presentation structure within pivot table. It is supported when the underlying data source allows this operation. A pivot listener will be notified after a pivot event is successfully performed. This operation can be enabled using pivotEnabled property of pivot table.

Sort

Sort operation is used to sort the data within pivot table. It is supported when the underlying data source allows this operation. A sort listener will be notified after a sort event is successfully performed. sortMode attribute specifies if sort operation is enabled, and which type of sort should be used.

Status Bar

Pivot Table provides status bar that will be shown when pivot table's attribute statusBarRendered="true". It provides selection information, i.e. current selection type and number of cells/rows/columns selected.

Child Tags

This component can be the parent of:

• <dvt:dataCell> is used to specify read-only as well as input component type for each data attribute

Example

• The following shows an example of using Pivot Table component
  

                 
                  <dvt:pivotTable                 
                             value="#{pivotTableEditBean.dataModel}" /> 
                 
         
  

• The following shows an example of specifying listeners for various pivot table operations

                  <dvt:pivotTable id="goodPT"
                             value="#{richPivotTableModel.dataModel}"
                         pivotListener="#{richPivotTableBean.handlePivotEvent}"
                             drillRequestedListener="#{richPivotTableBean.handleDrillRequestedEvent}"              
                         sortListener="#{richPivotTableBean.handleSortEvent}"                
                  /> 
         
  

Events

Attributes