Normal 0 false false false EN-AU X-NONE X-NONE MicrosoftInternetExplorer4 We are about to sell drink vouchers on Tess (on line and through our counter) as an add on with a ticket.
We want to see if we can create a voucher expiry date from the date of the show that is in the cart (i.e show date 3/5 so expiry date for drink voucher 3/8th – 3 months after the show date) BUT if there are more than 1 show date in the cart, (i.e the constituent has purchase 2 x shows) we want it to pull from the eldest show date – the date furthest in the future.
It would obviously require a user defined element to be created but do you think we could create the logic to do that – masking would be needed I assume.
Anyone?
Hi Ranie
You'll want to get one of your SQL bods to update the LP_TICKET_ELEMENTS stored procedure, with something matching the following;
select @ude_value = dateadd(month,3, max(c.perf_dt)) from t_order a join t_sub_lineitem b on a.order_no = b.order_no join t_perf c on b.perf_no = c.perf_no where a.order_no = @order_no and a.customer_no = @customer_no
In the example above me are adding +3 months to the max performance date in the sub lineitem table.
You can then draw these vaules out on the tickets with some user defined elephants.
Thanks, Ben
I never knew elephants could be user defined - which zoo has these??
Cheers - will get the SQL masters to have a look at this
Thanks