Customizing the Columns of a Pivot Table

1. Add the pviot table to the page.

2. Add varStatus and var attributes to dvt:pivotTable. Add dvt:dataCell, a switcher and configure as below

3. You can add a button, link etc.

4. Download the complete example here.

Note: If you are using export, the switcher component does not work. Add rendered property ( rendered="#{cellStatus.cellIndex.column==0} ) to control the values exported.

Using af:Iterator with master/detail to display data in custom layouts

Below example shows steps to use af:iterator in a master/detail senario

1. Create a ADF BC components(EO, VO, AM) with the viewlink for master/detail.

2. Drag and drop the master on to the page as tree table.

3. Create the first iterator to access the master collection via above tree binding, create the second iterator via the accessor binding. (Accessor name is present in the binding defination also in the view link defination)

4. You can create different combination of layout with this approach.

5. You can download the complete example here.

Master Form Detail SelectManyChoice

In my earlier post I showed an example to use SelectManyShuttle as a detail in Master-Detail pattern, you can also use other multi select components as details.

Below shows SelectManyChoice being used as the detail.

All you need to do is in step 6 (from post) just update the page xml as below instead.

Master Form Detail Multi Select Shuttle Pattern

Below Example demonstrates having Master Form with detail as Multi Select Component.

      1.       Data Model. Each Employee can have one or more skills. All possible skills are stored in SKILLS table. Each employee skills are stored in EMPLOYEE_SKILL.

This example user Oracle default HR Schema, additional tables can be created from SelectManyShuttle\DB\database\XE\CreateSchema.sql. File is available in the application zip.

      2.       Setup the Application Module Data Model as below.

      3.       From the Data Control Panel drag and drop the Employee -> EmployeeSkill as ADF Master Form, Detail Table as below

        4.       Create a request scope Bean and add setter and getter method as below

      5.       Now to create a List of all skills add a Table binding. Go to page bindings tab, click the add under bindings. Select tree. Add a new root data source. Select Skills view object. Select the Add Icon and Add Rule. Select SkillId, SkillName as Display attributes.

       6.       Delete the skills table, and a SelectMultiShuttle component. Bind the value to bean property. To dynamically create a selectItem list, we’ll use a forEach loop.

      7.       For the current employee the available skills should get defaulted to employee skills from EMPLOYEE_SKILL table, accordingly when the items are updated the rows need to get added/removed accordingly. We’ll add the logic in setters and getters to achieve this.

        8.       Download the complete example here.