Trying to create an output set that would include last date and amount for both tickets and contributions. I found the 'Most Recent Cont Date' element but can't find one for amount of most recent contribution, or for most recent ticket purchase date and amounts. Assuming I'm not missing something and there's no standard output element for those data points, does anyone have a recipe for building those output set elements? I'm sure there's been a forum answer on this before but struggling to find a recent post on the topic in the depths of the archives.
You (or someone in your org) can create elements for "Most Recent" contribution data. The VS_ELEMENTS_MEMBERSHIP_MOST_RECENT view provides for many options.We created "Most Recent" elements for each of our Membership Orgs.
We haven't created any elements for Last Ticket Purchased but there is a "recipe" in the Output Set Cookbook for Last Performance Purchased that might be what you're looking for.
Thanks for pointing me towards that recipe, that gave me the first half of what I was looking for! Anyone know a recipe to get the amount of the last ticket purchase?
Hi Erin!
I believe ticket amount is also in VS_ELEMENTS_TICKET_HISTORY, so in theory you could use the same pattern as the other columns in that custom view and just add it on to the end when creating the view?
(select top 1 f.tck_amt from VS_ELEMENTS_TICKET_HISTORY fJOIN VRS_SEASON s5 (NOLOCK) on f.season = s5.id where f.perf_dt = max(a.perf_dt) and s5.type not in (0) and f.customer_no = a.customer_no) as 'tck_amt'
And by "add it to the end" I mean add it to the end of the SELECT statement
Side note: be sure not to count on it showing today's purchases. Everything TICKET_HISTORY is refreshed overnight (and only for printed seated at that).