How to get Consolidated output using Bursting data model
I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule the report employee is receiving multiple emails for different courses.
My concern is to get the list of courses in a single email not to trigger multiple emails based on the no of courses employees have.
Below is the query used for this:
PAPF.PERSON_NUMBER as "KEY",
'Overdue Learnings' OUTPUT_NAME,
'Quess Corp'||' '||'[email protected]'PARAMETER3,