Greetings All,
I am hoping there is just something simple I am missing. I created an output set using several custom output elements which I feed into some automations outside of tessitura by pulling them out of an excel email attachment. When I apply the output set to a list in the system, everything works. When I run the "Execute and Output Set" utility in Tess, everything works, but when I schedule it with an "Email-Excel" output, 1 element keeps coming in blank. The element is pulling the "notes" field from T_STEP (given specific criteria) so it should just be a basic string.
Has anyone experienced this or have any idea what may be causing this one field to fail.
If it helps, here is my SELECT statement from the Query Element Group table. (The "Deposit Amount" is my issue)
(SELECT o.customer_no,l.li_seq_no,l.num_seats_pur,o.order_dt,o.order_no,l.perf_no,c.fname +' '+ c.lname AS company_name,r.fname +' '+ r.lname AS customer_name,address,GETDATE() AS invoice_date,o.created_by,sd.due_dt AS deposit_due_dt,sb.due_dt AS balance_due_dt,i.description AS perf_name,f.perf_dt,l.tot_pur_amt,o.tot_due_amt,sd.notes AS deposit_amt,o.tot_paid_amt,o.tot_due_amt-o.tot_paid_amt AS balance_amtFROM T_LINEITEM l JOIN T_ORDER o ON o.order_no = l.order_no JOIN T_CUSTOMER c ON c.customer_no = o.customer_no JOIN T_CUSTOMER r ON r.customer_no = o.initiator_no JOIN T_EADDRESS e ON e.customer_no = o.initiator_no AND e.primary_ind = 'Y' JOIN T_PERF f ON f.perf_no = l.perf_no JOIN T_INVENTORY i ON f.perf_no = i.inv_no JOIN T_PLAN p ON p.plan_no = (SELECT MAX(plan_no) FROM T_PLAN WHERE customer_no = o.customer_no) JOIN T_STEP sd ON sd.plan_no = p.plan_no AND sd.step_type = 28 JOIN T_STEP sb ON sb.plan_no = p.plan_no AND sb.step_type = 29)
Hi! Did you find a solution to this? I just came across the same issue - I have step notes in my output set. I can data in that column when I view the output set through List Manager and when I export directly from List Manager that column is populated, but when I schedule "Execute an Output Set" to email to me, that column shows up blank.ThanksJess
Unfortunately, no. I had to recode a workaround. Hopefully Tessitura is able to fix this in a future update.
Bummer. I see it in the reported defect list so maybe a solution soon...