• Replies 2 replies
  • Subscribers 414 subscribers
  • Views 101 views
  • Users 0 members are here
Related

Ticket Design Seat Number Masking

Katie Springer
$organization

I have read most of the forum posts about masking and I thought that I had found a way to get the seat numbers in a GA section to not display, but nothing I've tried is working. Here's the background, I renumbered the GA section so that the seat numbers begin at 100. No other seats in the house have numbers that high. I have successfully changed the zone name via masking and have gotten the row number to not display if it's GA. I thought if I used the same basic code but said If(val>'99', ' ' , val) I'd be good to go, but no dice. I've tried at least a dozen variations of If and Case statements. It either displays my code or prints the seat number anyway. 

Is the problem that it isn't one for one replacement? Does anyone know any way around this?

Any and all thoughts GREATLY appreciated!

  • $organization

    Hi Katie,

    We were having a similar issue with GA shows and we weren't able to get this to work with masking but we were able to use one of the user definable elements to do this.

    You will need your database admin to update the stored procedure LP_TICKET_ELEMENTS to add in the user element.  The code that we use to change ours is listed below.  For us, we change anything that has a section description of 'General Admission' to change the seat number to say 'GA' but you could change this to '' to make it display blank.  You may have to tweak this code to work with how you have things built in your system.

    Once you have the code in the stored procedure, in ticket design you can use the User-Defined Data group and User-Defined Element # where the number is the number you created in your stored procedure (ours is 2 because we have multiple items) to insert the item into your ticket design.

    Code:

    If @ude_no = 2
	Select
		@ude_value = case when TR_SECTION.description = 'General Admission' then 'GA' else TX_PERF_SEAT.seat_num end	
	From
		T_SUB_LINEITEM
		inner join TX_PERF_SEAT on T_SUB_LINEITEM.sli_no = TX_PERF_SEAT.sli_no
		inner join T_SEAT on T_SUB_LINEITEM.seat_no = T_SEAT.seat_no
		inner join TR_SECTION on T_SEAT.section = TR_SECTION.id
	Where
		T_SUB_LINEITEM.sli_no = @cur_sli_no
  • $organization

    Hi Katie,

    Have you tried something like If(val > 99, '', upper(val)  (the '' in the middle are two single quotes)? I've used a similar mask to hide row info in the past.

    Sara