Google Visualizations-OrgChart
Google Visualizations-OrgChart Tweet |
|
|
Categories:
Region Plugin
Who's the boss?Create a cool OrgChart with just a SQL statement. Since recently either Google changed something or 4.1.1 caused it, but now all columns need to be defined as character! The example in the demo (and the picture below) is created with: select to_char(emp.empno) as primary_key , to_char(emp.mgr) as parent_key , emp.ename ||'<div> <img width="100px" xsrc="wwv_flow_file_mgr.get_file?p_security_group_id='|| :WORKSPACE_ID|| '&p_flow_id='||:APP_ID||'&p_fname='||emp.empno||'.jpg"> </div>' ||'<div style=''font-size:75%''>' ||emp.empno ||'</div>' ||'<div style=''color:red; font-style:italic''>' ||initcap(job) ||'</div>' as display_value , initcap(dept.dname)||' ('||initcap(dept.loc)||')' as tooltip , job , dept.dname as department , dept.loc as location from emp , dept WHERE emp.deptno = dept.deptno
Special Requirements Fixed bug so it runs in 4.1.1 Keywords
|
Company:
Date added: 23.2.2012
Views:
4914
Votes:
8
Reviews:
7
Min. APEX Version:
4.0
Link to:
Download
If something is not correct please report it here:
Report Listing
|
Share on Digg
Save This Page|
|
|
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first. Reviews / Questions / Comments are e-mailed to the author of the Plug-in. |
Thx for your post. I have a problem, I can't show the chart in the region in execute mode. It is always loading. I use Apex 4.1. You could find the region source code below:
select
to_char(emp.emp_id) as primary_key
,to_char(e.emp_supervisor_id) as parent_key
,to_char(emp.last_name||', '||emp.first_name)
||'
||'
||'
,emp.job_id
,emp.position_id
,emp.location_id
from per_employees emp, per_employees e
where e.emp_supervisor_id = emp.emp_id(+)
and emp.emp_id is not null;
Could you help me to fix this. Thx in advance
Bart,
This looks like it could be really cool, only when I deploy using the select above, it get the source code in each org chart node e.g.
KING
It there something special I have to do to get correct rendering?
Thanks
Mike
both horizontally and vertically.?
example http://google-visualization-api-issues.googlecode.com/issues/attachment?aid=-3655943449810417064&name=org_chart_vertical.png&token=8cLLdO2OOa1ShB_cHy3x7njwYDA%3A1345543108910&inline=1
there is a similar question on this site
http://code.google.com/p/google-visualization-api-issues/issues/detail?id=47#c16
and i have tried to implement the suggestion in comment 16 but without success
can you help me?
Be aware " all columns need to be defined as character". So what is your query?
Roel
I have tried it in i.e. 8 and 9.
How come the on line demo works in explorer too?
Has it any difference with the downloadable version ?
| Powered by Sigsiu.NET |  |