Forum Stats

  • 3,770,570 Users
  • 2,253,135 Discussions
  • 7,875,497 Comments

Discussions

oracle apex IR with link column with listagg values to send single value

ragu_s
ragu_s Member Posts: 66 Blue Ribbon

Hello,

I am trying to send single value on '|' separated link column, any inputs will be helpful. I have setup an example within my personal workspace.

So, for example in my report if I click on first accounting row for employees(s) column on hello1, it should only pick this value not the whole 'ADAMS|HELLO1|JACKIE|JONES|King|WARD'.

I am using below sql for report query and made employee(s) as link column to redirect to modal dialog.

Workspace Details:

workspace: raghu_workspace

username/password: test/test12345

App# 25244, Pg# 1 & 2.


SELECT

  t1.dname,

  LISTAGG(

    t2.ename,

    '|'

  ) WITHIN GROUP(

  ORDER BY

    t2.ename

  ) AS employees

FROM

  dept t1, emp t2

  where t1.deptno = t2.deptno

GROUP BY

  t1.dname

ORDER BY

  t1.dname;




Thanks,

Ragu

Comments