255 total views, 1 views today

How to create ADF DVT Pie Chart from custom SQL Query

In this section, we walk through about creating an ADF DVT Pie Chart from a custom SQL Query The below query uses aggregate function SUM and GROUP BY clause of an Employee table which returns salary by Job-Title.

 

1. Right click on the Model project >> New >> View Object >> Click Next

121716_2330_Howtocreate1 How to create ADF DVT Pie Chart from custom SQL Query with Group By option

 

2. Input the query and click multiple Next >> Add the View Object to the App Module and Click Finish

select sum(salary) as salary, job_id as a job from employees group by job_id

121716_2330_Howtocreate2 How to create ADF DVT Pie Chart from custom SQL Query with Group By option

 

 

3. Create a JSF page under Web Content >> Drop the view Object into the JSF page >> Select Chart >> Select Pie >> Click Ok

4. Select Salary in the Pie and Job in the Slices. Click Ok

121716_2330_Howtocreate3 How to create ADF DVT Pie Chart from custom SQL Query with Group By option

 

 

5. Run the page will give the following page

121716_2330_Howtocreate4 How to create ADF DVT Pie Chart from custom SQL Query with Group By option

 

 

6. To turn on the 3D effect of the Pie chart, Change the property ThreeDEffect = On for <dvt:pieChart> as shown below

121716_2330_Howtocreate5 How to create ADF DVT Pie Chart from custom SQL Query with Group By option

 

 

7. After that, the PieChart will display in 3DEffect

121716_2330_Howtocreate6 How to create ADF DVT Pie Chart from custom SQL Query with Group By option

govindan How to create ADF DVT Pie Chart from custom SQL Query with Group By option
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to create ADF DVT Pie Chart from custom SQL Query with Group By option
Connect me
By | 2016-12-17T18:42:11+00:00 December 17th, 2016|Categories: ADF|Tags: , , , , |0 Comments
Like us on Facebook.
Connect!