<dvt:dataCell>

dvt:dataCell dataCell data cell

UIComponent class: oracle.adf.view.faces.bi.component.pivotTable.UIDataCell
Component type: oracle.dss.adf.pivotTable.DataCell

Data cell component provides stamping to customize the content. For example, each data cell content can contain a read-only or an input component. This tag also supports customized CSS style for the cells.

Data Cell Features

Stamping

The child component of each Data Cell displays the data for specific data attribute in the pivot table. Data Cell does not create child components per data attribute; instead, each data cell is repeatedly rendered (stamped) once per data attribute. Because of this stamping behavior, only certain types of components are supported as children inside a Data Cell. Supported components include all components with no behavior and most components that implement the EditableValueHolder or ActionSource interfaces.

As data attribute is stamped, the data for the current data attribute is copied into an EL reachable property. The name of this property is defined by the var property on the Pivot Table. Once the Pivot Table has completed rendering, this property is removed (or reverted back to its previous value). In the following example, the data for each row is placed under the EL property "cellData". Each data cell displays the data for each data attribute by getting further properties from the "cellData" property:

        
                        <dvt:pivotTable var="cellData" >
                            <dvt:dataCell dataAttribute="Sales">                    
                                 <af:inputText  value="#{cellData.dataValue}"   />  
                            </dvt:dataCell>
                            <dvt:dataCell dataAttribute="Weight">
                                <af:outputText value="#{cellData.dataValue}" />
                            </dvt:dataCell>                   
                            <dvt:dataCell dataAttribute="Available">                    
                                <af:selectBooleanCheckbox id="idselectbooleancheckbox" label="Availability" text="Item Available"
                                              autoSubmit="true" value="#{cellData.dataValue}"/>                    
                            </dvt:dataCell>
                        </dvt:pivotTable>
        
        

Customized Cell Content and Style

For customizing data cell content, use DataFormat. DataFormat attribute returns 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

Data Cell content can be specified by various ways:

• defining the data cell by measure ( this is also discussed in the previous section above )
• specifying the default data cell contents

The following example shows how Data Cell supports alternative cell content using <af:switcher> based on the stamping property. In other words, the stamping content is customized on a cell by cell basis depending on a variable value ("#{richPivotTableModel.stampFacet}"). The example also shows custom CSS styling using inlineStyle and contentStyle attributes of outputText and inputText respectively.

        
                <dvt:pivotTable 
                           value="#{richPivotTableModel.dataModel}"
                           var="cellData"
                           varStatus="cellStatus" >          
        
                            <dvt:dataCell>      <!-- only one data cell is used as default for all measures -->
                              <af:switcher facetname="O__richPivotTableModel_stampFacet_">
                                <f:facet name="outputText">               
                                  <af:outputText  value="#{cellData.dataValue}" inlineStyle="#{cellStatus.cellFormat.textStyle}"/>    
                                </f:facet>  
                                <f:facet name="inputText">  
                                  <af:inputText  value="#{cellData.dataValue}" contentStyle="#{cellStatus.cellFormat.textStyle}" />   
                                </f:facet>
                          </af:switcher>
                            </dvt:dataCell>
                </dvt:pivotTable>
        
        

The following example uses dataAttribute attribute to determine the type of input component inside data cell based on different measures.

        
                        <dvt:pivotTable var="cellData" >
                            <dvt:dataCell dataAttribute="Sales">                    
                                 <af:inputText  value="#{cellData.dataValue}"   />  
                            </dvt:dataCell>
                            <dvt:dataCell dataAttribute="Weight">
                                <af:outputText value="#{cellData.dataValue}" />
                            </dvt:dataCell>                   
                            <dvt:dataCell dataAttribute="Available">                    
                                <af:selectBooleanCheckbox 
                                              autoSubmit="true" value="#{cellData.dataValue}"/>                    
                            </dvt:dataCell>
                    <dvt:dataCell>  <!-- this is the default data cell that will be used for data attributes other than the ones specified before-->
                                 <af:outputText  value="#{cellData.dataValue}"   />  
                            </dvt:dataCell>       
                        </dvt:pivotTable>
        
        

Supported Child Tags

The components that are supported by <dvt:dataCell> include but not limited to the following:

• <af:switcher>
• <af:outputText>
• <af:inputText>
• <af:selectOneChoice>
• <af:selectBooleanCheckbox>
• <af:inputDate>
• <af:commandLink>
• <af:inputComboboxListOfValues>

Example

The following example shows a way to use stamping, and to use one data cell as default content for pivot table

        
                <dvt:pivotTable id="goodPT"
                           value="#{pivotTableEdit.dataModel}"                                         
                           var="cellData"
                           varStatus="cellStatus">
                            <dvt:dataCell>                    
                                 <af:outputText  value="#{cellData.dataValue}"   />  
                            </dvt:dataCell>
                 </dvt:pivotTable>
        
        

Events

Attributes