Ticket Design

Thank you Ken.

DARRELL JONES | Assistant Box Office Coordinator | Tasmanian Symphony Orchestra Pty Ltd

1 Davey Street, Hobart, Tasmania | GPO Box 1450 Hobart, Tasmania                                        

Tel 03 6232 4404 | Email jonesd@tso.com.au | Website www.tso.com.au

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ken McSwain
Sent: Friday, 5 September 2014 12:18 PM
To: Darrell Jones
Subject: Re: [Tessitura Ticketing Forum] Ticket Design

Hi Darrell

Needs a little back-end work, but its not hard to do, if you have access to some basic SQL skills.

You can create a user-defined ticket element by modifying the proc LP_TICKET_ELEMENTS, which you can then use on your tickets in the same way as the pre-defined elements.

And there's a function to use in your new element which will return the same string of constituency codes for a constituent that you get on the constituent header.

[dbo].[FS_CONST_STRING_NEW]  (@customer_no int, @include_affiliates char(1))

Your code would look something like this:

If @ude_no = 1 and @customer_no > 0

Select @ude_value =  coalesce (left( [dbo].[FS_CONST_STRING_NEW]  (@customer_no, 'Y'), 30)  ,'')

Ken

Hello all,

Has anyone devised and easy (and inexpensive) way of printing the 3 character short description of a Constituency on a ticket?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thank you Ken.

DARRELL JONES | Assistant Box Office Coordinator | Tasmanian Symphony Orchestra Pty Ltd

1 Davey Street, Hobart, Tasmania | GPO Box 1450 Hobart, Tasmania                                        

Tel 03 6232 4404 | Email jonesd@tso.com.au | Website www.tso.com.au

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ken McSwain
Sent: Friday, 5 September 2014 12:18 PM
To: Darrell Jones
Subject: Re: [Tessitura Ticketing Forum] Ticket Design

Hi Darrell

Needs a little back-end work, but its not hard to do, if you have access to some basic SQL skills.

You can create a user-defined ticket element by modifying the proc LP_TICKET_ELEMENTS, which you can then use on your tickets in the same way as the pre-defined elements.

And there's a function to use in your new element which will return the same string of constituency codes for a constituent that you get on the constituent header.

[dbo].[FS_CONST_STRING_NEW]  (@customer_no int, @include_affiliates char(1))

Your code would look something like this:

If @ude_no = 1 and @customer_no > 0

Select @ude_value =  coalesce (left( [dbo].[FS_CONST_STRING_NEW]  (@customer_no, 'Y'), 30)  ,'')

Ken

Hello all,

Has anyone devised and easy (and inexpensive) way of printing the 3 character short description of a Constituency on a ticket?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!