Google Visualizations-OrgChart Tweet
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
<img width="100px" xsrc="wwv_flow_file_mgr.get_file?p_security_group_id='||
||'<div style=''color:red; font-style:italic''>'
||'</div>' as display_value
, initcap(dept.dname)||' ('||initcap(dept.loc)||')' as tooltip
, dept.dname as department
, dept.loc as location
WHERE emp.deptno = dept.deptno
Fixed bug so it runs in 4.1.1
Do you have a question about this Plugin? Want to write a Review or Comment?
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:
to_char(emp.emp_id) as primary_key
,to_char(e.emp_supervisor_id) as parent_key
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
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.
It there something special I have to do to get correct rendering?
both horizontally and vertically.?
there is a similar question on this site
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?
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|