Question
Infosys Limited
US
Last activity: 11 Jun 2020 16:57 EDT
Generate multiple pulse post messages in a single report.
Hi all,
I have a scenario where the application has several case types. I already have a report definition to see the cases created for all the case types. Now, I wanted to add all the pulse post messages to be visible in the report for each case which I already have. If there are multiple posts for each case, then the messages should be separated by a single line.
How could I implement this scenario?
Thanks in advance.
***Edited by Moderator Marissa to update General to Product***
Updated: 11 Jun 2020 16:57 EDT
Maantic Inc
US
Option 1
Create db view with below query, it will get all the pulse entry in one row for given case id. connect view with report definition
SELECT
wk.* ,(SELECT
listagg (pyobject, ',') within group (order by pyobject)
FROM
pc_work_social sc
WHERE
sc.pyindirectobjectid = wk.pzinskey ) as pluseMessages
FROM
pc_work wk
Listagg reference: https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030
Option 2
In a Datapage
Call Case RD
Call Pulse RD
Loop pulse values - concat under one property
Update the datapage