BI Publisher Bursting Issue
778337Jan 20 2011 — edited Jan 21 2011Hello everyone,
we can burst the same report to multiple users as shown below. but the issue is if we want to send a same report by each district to tht particular manager email id then wht could be the sql query it has to select tht particular district and the manager email id when bursting..
SELECT department KEY
,'Standard Report' TEMPLATE
,'RTF' TEMPLATE_FORMAT
,'en-US' LOCALE
,'Excel' OUTPUT_FORMAT
,'Email' DEL_CHANNEL
,'abc@abc.com,def@def.com,ghi@ghi.com' PARAMETER1
,'qwe@qwe.com' PARAMETER2
,'asd@asd.com' PARAMETER3
,'Standard Report' PARAMETER4
,'Find the Report Below.' PARAMETER5
,'true' PARAMETER6
,'donotreply@nowhere.com' PARAMETER7
FROM
dual
Thanks...