This discussion is archived
1 Reply Latest reply: Mar 30, 2013 7:17 AM by VC RSS

How to refer image from table in organization chart

930803 Explorer
Currently Being Moderated
Hi Everyone,

I am using org chart plugin to show the employee hierarchy, the plug-in is downloaded from http://apex-plugin.com/oracle-apex-plugins/region-plugin/google-visualizations-orgchart_187.html

Current i uploaded the employee photo's in images under shared components -> files and referring in my query like below its working fine, but My question is how to refer employee photo's from table.
SELECT   TO_CHAR (emp.empno) AS primary_key,
         TO_CHAR (emp.mgr) AS parent_key,
         emp.ename
         || '<div>
<img width="100px" src="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
Brgds,
Max

Legend

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