Unable to pass multiple email addresses to Bursting definition
Hi All,
I've created a bursting definition for a Sales Order report and output is to be delivered to individual salespersons. I have the salespersons name and email addresses in my main query and using the same in parameters section of Bursting definition. Please see below example.
SELECT
PARTY_NAME KEY,
'Detail' TEMPLATE,
'en-US' LOCALE,
'EXCEL' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
'SO DETAIL REPORT' OUTPUT_NAME,
EMAIL_ADDRESS parameter1
FROM (
SELECT DISTINCT HZPAS.PARTY_NAME, jrp.EMAIL_ADDRESS
FROM
DOO_HEADERS_ALL DOHA
……………..
)
However, it shows an error that it's not a Selected expression.
Any inputs on this is greatly appreciated.