(cross posted in Admin/IT)
I'm trying to add a user-defined element for ticket designs but I think I'm missing a step. I've modified LP_TICKET_ELEMENTS with the following (taken from sample code but removing the design type "h" because I want it to be available in the ticket part not header.) Then what? Is that all I need to do? I'm not seeing it listed as an option in the dropdown when adding it to a ticket design (it's still listed as "user defined element 2".) But I've added it to my PAH ticket design and corresponding PDF template and nothing is printing. I've confirmed that ft_membership_info returns a membership level with the same customer no as the order.
If @ude_no = 2 and @customer_no > 0Select @ude_value = IsNull(memb_level_desc, '')From ft_membership_info(@customer_no, 1, null)
Odele