Skip to Main Content

ORDS, SODA & JSON in the Database

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!

Organizational Chart in Apex

Edwin TDec 30 2014 — edited Jan 6 2015

Is there a simple way to create an organizational chart in Apex 4.2. Tried the apex-plugin.com Google Visualizations plugin at http://apex-plugin.com/oracle-apex-plugins/region-plugin/google-visualizations-orgchart_187.html as suggested in one Oracle Article, but it just shows a "loading" graphic and nothing appears. I've tested the SQL and it works fine. The Javascript console in Google Chrome shows the following:

The value "device-width;" for key "width" is invalid, and has been ignored.

f:41 The value "1.0;" for key "initial-scale" was truncated to its numeric prefix.

f:41 The value "1.0;" for key "maximum-scale" was truncated to its numeric prefix.

f:41 Error parsing a meta element's content: ';' is not a valid key-value pair separator. Please use ',' instead.

wwv_flow_file_mgr.get_file:16 {"cols":[{"id":"col1","label":"PRIMARY_KEY","type":"string"},{"id":"col2","label":"PARENT_KEY","type":"string"},{"id":"col3","label":"DISPLAY_VALUE","type":"string"},{"id":"col4","label":"TOOLTIP","type":"string"}],

}

https:/......./apex/f?p=1234:1000:1000000000000::::: Failed to load resource: net::ERR_CACHE_MISS

Note: session and app URL info have been changed to generic values.

Any Idea what I might be doing wrong, or is there any other solution , preferrably  built-in, but will work with something that can be implemented easily.

Thanks in Advance.

Comments

TexasApexDeveloper

Might want to post this to the proper forum.. This is the ORDS (Formerly APEX Listener) forum.. The APEX support forum is located here:Application Express

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

TexasApexDeveloper

Also here is an example of doing an Org tree in APEX using css3 coding: http://rokitta.blogspot.com/2013/12/pure-css3-org-tree-with-apex-list.html

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

Edwin T

Thanks. The second solution worked.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 3 2015
Added on Dec 30 2014
3 comments
2,420 views