Donation revenue from ceratin seats in the house

You can use Subscription Series and Subscription-Section in the Ticketing folder of List Manager if your premium seats comprise an identifiable section as defined in TR_SECTION. Once you have a list of people in that section, you can run a report to find their gifts.

This is a little glitchy; in our system, I had to edit Subscription-Section in T_KEYWORD so that the ref_where column says print_desc is not null (it had print_desc <> null before). I also had to edit Subscription Series so that ref_tbl looks at vs_pkg, ref_idcol at pkg_code, and ref_desccol at description. Otherwise, no drop-down menu.

I don’t know if my T_KEYWORD table is defective. Those two rows hadn’t been updated at all until I touched them today.

If you need to go by specific section/row/seat values, you can pop the following query into the Manual Edit section of a new list, replacing

·         ‘12M-SAT’ with your package code (keep the single quotes; the ticket office or IT can give you the package code(s) you need if you can’t find it);

·         ‘Grand Tier%’ with the exact section description you want as it appears in TR_SECTION;

·          ‘A’,’B’,’C’ replaced with whatever rows you are looking for;

·         ‘1’,’2’,’3’,’4’,’5’,’6’,’7’,’8’ replaced with whatever seat numbers you are looking for

Select Distinct a.customer_no

 From t_customer a (NOLOCK)

JOIN TX_PERF_SEAT b (NOLOCK) ON a.customer_no = b.customer_no

JOIN T_SEAT c (NOLOCK) on b.seat_no = c.seat_no

Where  IsNull(a.inactive, 1) = 1

 AND b.pkg_no in (select pkg_no from VS_PKG where pkg_code = '12M-SAT')

AND c.section in (select id from TR_SECTION where description like 'Grand Tier%')

AND (c.seat_row in ('A','B','C') or c.seat_row = '')

AND c.seat_num in ('1','2','3','4','5','6','7','8')

Lucie

You can use Subscription Series and Subscription-Section in the Ticketing folder of List Manager if your premium seats comprise an identifiable section as defined in TR_SECTION. Once you have a list of people in that section, you can run a report to find their gifts.

This is a little glitchy; in our system, I had to edit Subscription-Section in T_KEYWORD so that the ref_where column says print_desc is not null (it had print_desc <> null before). I also had to edit Subscription Series so that ref_tbl looks at vs_pkg, ref_idcol at pkg_code, and ref_desccol at description. Otherwise, no drop-down menu.

I don’t know if my T_KEYWORD table is defective. Those two rows hadn’t been updated at all until I touched them today.

If you need to go by specific section/row/seat values, you can pop the following query into the Manual Edit section of a new list, replacing

·         ‘12M-SAT’ with your package code (keep the single quotes; the ticket office or IT can give you the package code(s) you need if you can’t find it);

·         ‘Grand Tier%’ with the exact section description you want as it appears in TR_SECTION;

·          ‘A’,’B’,’C’ replaced with whatever rows you are looking for;

·         ‘1’,’2’,’3’,’4’,’5’,’6’,’7’,’8’ replaced with whatever seat numbers you are looking for

Select Distinct a.customer_no

 From t_customer a (NOLOCK)

JOIN TX_PERF_SEAT b (NOLOCK) ON a.customer_no = b.customer_no

JOIN T_SEAT c (NOLOCK) on b.seat_no = c.seat_no

Where  IsNull(a.inactive, 1) = 1

 AND b.pkg_no in (select pkg_no from VS_PKG where pkg_code = '12M-SAT')

AND c.section in (select id from TR_SECTION where description like 'Grand Tier%')

AND (c.seat_row in ('A','B','C') or c.seat_row = '')

AND c.seat_num in ('1','2','3','4','5','6','7','8')

Lucie