Add Extra Display Column in IG - Interactive Grid
Posted: Wed Nov 10, 2021 8:08 am
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.
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.