This discussion is archived
0 Replies Latest reply: Dec 15, 2008 2:14 PM by 145158 RSS

Display bar chart of the currently selected row only

145158 Newbie
Currently Being Moderated
I am using JDeveloper R11. I have a database table with four columns, for example ID, C1, C2, C3. The table has several rows.

I have created an ADF BC model with a default ViewObject on the above table. Than on a JSPX page I would like to drop a bar chart, displaying all three columns (C1, C2, C3) of the currently selected row only.

When I drop the DataControl on the page as a graph, I select horizontal bar chart type, define the bars as C1, C2, C3 and the Y axis as ID.
<graph IterBinding="MyTableViewIterator" id="MyTableView"
       xmlns="http://xmlns.oracle.com/adfm/dvt" type="BAR_HORIZ_CLUST">
  <graphDataMap leafOnly="true">
    <series>
      <data>
        <item value="C1"/>
        <item value="C2"/>
        <item value="C3"/>
      </data>
    </series>
    <groups>
      <item value="ID"/>
    </groups>
  </graphDataMap>
</graph>
What I get is a group of 3 bars for all the rows in the table.

My question: is there an easy way to display the 3 bars of the currently selected row in the View Object. I do not know, what can I write into the <groups> tag. I can change the row selection elsewhere in the application.

Thanks,

Istvan Kiss

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points