Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
dvt:pivotTable Table dynamically using Row set

Hi Expert ,
I have 2 VO master and details , now i use for each to show the master vo as panel box
now i need to show details VO as pivotTable how can i achieve such if i drag and drop as normal pivot table data shown for the first row in master view
i am using JDeveloper 12.2.1
Comments
-
Create ADF 12cR2 Fusion application.
Create Read only View Object(Custom Query) to get the data for Pivot table and add below query.
Drag & drop created VO to page and select Table/List view -> ADF Pivot table.
Refer blog https://insideclouldworld.wordpress.com/2016/07/17/adf-12cr2-data-visualizations/comment-page-1/
-
Thanks dvohra21 ,
i know how to add pivot table , but my issue is
lets say i have 2 vo DEPT and EMP DEPT is master of EMP
now in the page i am using FOR EACH to iterate the DEPT vo and show them as Panel Boxes
and i need to show the EMP vo as pivot table the panel box so each panel box shows the employee of the department as pivot table .
hope this clear my answer
Thanks Again
-
Master-Detail Data is typically displayed as Tables, Forms, and Trees. But a DVT Pivot table could also be used.
-
26.2.3 What You May Need to Know About Using a Graph's Row Selection Listener for Master-Detail Processing
You can use the row selection listener of a graph (which serves as a master view) to enable clicks on a bar, slice, or other graph data element to update the data in another ADF component (which serves as a detail view). For example, a click on a bar that represents sales for a given product in a graph might cause the display of the detailed sales data related to the product in a pivot table.
The following requirements must be met to achieve this master-detail processing declaratively:
- You must use the same data control to provide data for both views as follows:
- Bind the graph as a row set to the parent collection in the data control, for example,
DepartmentsView
. - Bind the other ADF view (such as a table or pivot table) to the dependent detail collection in the data control, for example
EmployeesView
.
- Bind the graph as a row set to the parent collection in the data control, for example,
- Select Set the current row for master-detail in the Create <type> Graph dialog to automatically set a value for the
clickListener
attribute of the graph tag and use theprocessClick
method that is already part of the graph binding. - For example, if the
value
attribute of the graph tag isvalue="#{bindings.myGraph.graphModel}"
, then theclickListener
attribute is set toclickListener="#{bindings.myGraph.graphModel.processClick}"
. - Ensure that the
partialTriggers
attribute on the parent tag for the detail component is set correctly. It should be set to the ID of the graph component.
You do not have to write Java code for handling clicks on data elements in the graph. The
processClick
event on the graph binding recognizes click events on data component in a graph and performs the necessary processing. - You must use the same data control to provide data for both views as follows:
-
Thanks dvohra21 ,
thanks for your kind help , i know the above but my issue is different
-
First use without Panel Box. If pivot table gets displayed, add Panel Box. The requirement is to add a pivot table within a Panel Box. Is it not?
-
Hi Dvohra
thanks for you kind support .
Master details is working , my issue is that i add the master vo rows as panel box in the page so the pivot show in all panel boxes data form the first master row .
-
Please post some code snippet with pivot table and panel box. May be panel box is not usable with pivot table.
"If layout is desired, a layout component like
af:panelGroupLayout
can be used instead."