Bursting with dynamic subject
Hello,
I have a data model with a Bursting definition using a SQL query on a bursting control table.
SELECT DISTINCT
cp.customer_code KEY
, cp.template_name TEMPLATE
, cp.template_type TEMPLATE_FORMAT
, 'en-US' LOCALE
, cp.output_format OUTPUT_FORMAT
, DECODE(cp.delivery_channel,'FILE', cp.file_name ,'EMAIL',
'MY_INVOICE' ) ||'.'||CP.OUTPUT_FORMAT OUTPUT_NAME
, 'false' SAVE_FORMAT
, cp.delivery_channel DEL_CHANNEL
, DECODE(cp.delivery_channel,'FILE', cp.file_loc , 'EMAIL', cp.email )
PARAMETER1
, DECODE(cp.delivery_channel,'FILE', cp.file_name ,'EMAIL',
'MY_INVOICE.pdf' ) PARAMETER2
, DECODE(cp.delivery_channel,'FILE',NULL ,'EMAIL',
0