1. Write an SQL as below,
select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
(select d.dname from dept d where d.deptno = emp.deptno) DEPT_NAME
from EMP
2. Keep all settings default and now click this DEPT_NAME column under IG and change the property to Query Only.
Add Extra Display Column in IG - Interactive Grid
Add Extra Display Column in IG - Interactive Grid
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 48 guests