I would like for one of my ticket designs to pull the Zone Description in the Section field of my format? Does anyone know what value I should enter in the T_Design_Elements table under User Defined Element 1?
First you need to assign a value to the user defined element in lp_ticket_element. You don't change anything in t_design_element. Just define the element in the stored procedure and then place it on your ticket design. I think this will get you zone_desc:
If @ude_no = 1 and @customer_no > 0
Select @ude_value = IsNull(description, '')
from t_sub_lineitem l
inner join tx_perf_seat x on l.sli_no=x.sli_no
inner join t_zone z on z.zone_no=x.zone_no
Where customer_no = @customer_no
and l.order_no=@order_no
and li_seq_no=@li_seq_no