Can you add to T_DESIGN_ELEMENT?

Tash,

You can only have 6 but that doesn't mean that you can't use the same ones for different purposes at the same time. I have and currently do use "IF" statements to target different performances. So you can nest the if statements for different performances Such as the example below.

    IF @ude_no = 1 AND

        @design_type = 'T'

        BEGIN

            DECLARE

                @perf_no INT ,

                @seat_no INT ,

                @Zone INT

            SELECT

                @perf_no = sl.perf_no ,

                @seat_no = s.seat_no ,

                @zone = sl.zone_no

            FROM

                t_seat s ,

                T_SUB_LINEITEM sl

--where sl.sli_no = @cur_sli_no

            WHERE

                sl.sli_no = @cur_sli_no AND

                s.seat_no = sl.seat_no

            IF @perf_no = 2358 OR

                @perf_no = 2399 OR

                @perf_no = 2403 OR

                @perf_no = 2532 OR

                @perf_no = 2536 OR

                @perf_no = 2540

                BEGIN

                    IF @Zone = 1324 OR

                        @Zone = 1330 OR

                        @Zone = 1337 OR

                        @Zone = 1343

                        SELECT

                            @ude_value = LTRIM(RTRIM(b.description))--'General Admission' -- Pulling for the door.

                        FROM

                            t_seat a ,

                            TR_SECTION b

                        WHERE

                            a.section = b.id AND

                            seat_no = @seat_no

                    ELSE

                        SELECT

                            @ude_value = LTRIM(RTRIM(b.additional_text)) +

                            '  ' + LTRIM(RTRIM(b.description))

                        FROM

                            t_seat a ,

                            TR_SECTION b

                        WHERE

                            a.section = b.id AND

                            seat_no = @seat_no

                END

        END

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Natasha Purkiss
Sent: Wednesday, June 13, 2012 5:23 PM
To: Martin A. Jones
Subject: [Tessitura Technical Forum] Can you add to T_DESIGN_ELEMENT?

I have a feeling the answer to my question is a big 'NO', but thought it worth asking....

As there is a limit of 6 user-defined elements for ticket design purposes, can I add another to T_DESIGN_ELEMENT to create more? We have used up our 6 and need another!

Thanks, 

Tash 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!