Bursting: Email body with information from Data Set result
Hello.
Version:
BIP 11.1.1.7
Situation.
Data set returns a result with N rows, that is exported to Excel file and sent to the several users.
Problem.
How can I add information about number of rows to email body (PARAMETER5 in the query for delivery XML)? I tried to use GTT tables, but it did not help - it looks like BIP uses different sessions for Data Set execution and Bursting query. Could you please suggest the solution?
Delivery XML example.
select
1 KEY,
'RTF_TEMPL_1' TEMPLATE,
'es_ES' LOCALE,
'XLSX' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
'Results' OUTPUT_NAME,
0