Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updateable Pivot Table: Possible?

838924Feb 11 2011 — edited Feb 12 2011
Hi,

I am trying to find the right technology for a web based app I am goin' to write. I have done a great deal of apex development before. Now what I need at some point of time is a possibility to have a pivot table with updatable fields in it. Both rows and columns will be dynamic. Now I know this is gonna be a more complex task but I guess my question is is this possible in the first place?

To give you an example I will have a table with people and one with skills. In a third table I will join these together probably using a numerical value to assign the level of skill. A manager looking at their respective direct reports should now see a list of the people with a column per skill. This table now should be updatable with the above mentioned numeric value. From a useability standpoint it would be quite painful to go through every single employee individually and update the values per skill in there.

( Maybe already some ideas on how to do this? :-) )

Thanks for your help!
Henrik
This post has been answered by ATD on Feb 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2011
Added on Feb 11 2011
12 comments
1,266 views