Hi All,
I was hoping someone might be able to assist with some SQL code advice. I'm trying to setup a rule for ticket printing to add 'check id' to the ticket when a customer has a certain price type. I've found that I need to add a UDE rule to LP_TICKET_ELEMENTS but none of the examples I've found have been useful to use as a base.
does anyone have any code they might be able to share?
any advice would be appreciated!
Cheers
cam
Hey Cameron,
You can do this using the mask field in the ticket design element. I do this for order sources on our ticket headers and the mask value looks like this:
If ((val in ('3422','3423','3424','3425')),'*ID REQUIRED*',(If ((val in ('12362')),'*Drink Voucher*','')))
You'll need to adjust it for your price type ids, but the same principle should work.
Dorothy