Hello everyone,
I'm at work on revising the ticket design document and I'm in need of some conditional masking examples. If you are using conditional masking, would you share what you are doing and how you are doing it (i.e. what code you entered in to the Mask field)?
Many thanks,Kevin
Hey Kevin,
I didn't come up with the code personally but thought I would share.
We needed a flag or acronym on our design that let the Box Office know when a ticket had been Donated for Resale and sold again. The Resold Flag element under Data Group: Order did just that, but we didn't like that it returned "Donated Seat" on the ticket. It would have confused the next patron that bought the seat.
So IT came up with the case(val when 'Donated Seat' then 'DFR' else val) mask which returns "DFR" on the ticket. The Box Office knows what it means, and the patron will be none the wiser.
Not sure if that was what you were looking for, but I hope it helps! It did for us!
That’s exactly what I was looking for. Thanks for sharing!
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Hi Kevin
On our Post dockets we only wanted to display the Country field if the address was NOT in Australia. So on our Post docket format we put a mask on the field "Country Long":
If(val = 'Australia', '', upper(val))
So if the country is Australia then nothing is printed, else the Country is printed in UPPERCASE.
We needed a way to easily identify patrons in a particular zone, but didn't want (or have room for) the raw zone name to print on the ticket so we use the follwing Mask on the PMap Price Sec Desc field Case(val When 'Premium - Orchestra' Then 'PREMIER' When 'Premium - Tier 1' Then 'PREMIER' When 'Premium - Tier 2' Then 'PREMIER' Else ' ')