I am in the process of building an output set for our Triggered Email list, and I have run into a wall trying to build an element to pull the Performance Time into the set.
Has anyone found a way to build that in TR_QUERY_ELEMENT?
Any tips and tricks are welcome!
Hi Kira,
We pull through performance time in to our Wordfly emails using a local view LVS_TRIG_EMAIL_PRESHOW. It comes from UMS and was presented as a Mini Magic back in 2013.
I can't seem to figure out how to attach a file to the forums so I'll email you a copy.
Cheers,
dgh
Hey Kira, I can't find your email on your profile. Drop me a line and I'll send you the details: d.hall@festival.melbourne
As a side note, our view just looks at the perf_dt and does some SQL trickery to pull out the time in our preferred format: Ltrim(RIGHT(CONVERT(VARCHAR(20), perf_dt, 100), 7))