Removing Constituents already booked when doing an extraction

You need to know what your ticket history is picking up. In our case, patrons don’t have ticket history until the day after they are ticketed (the procedure that updates ticket history runs at night). I have therefore inserted SQL to look at something other than ticket history (I look at actual seat reservations for patrons in the view VX_PERF_SEAT) when I need to suppress unticketed patrons.

If the query in your list is looking for a.customer_no, add this into the Where clause (edit season 58 to the season you are looking for, or, if you know the perf_no, put that into the “select perf_no” parenthetical statement instead of what’s there:

and a.customer_no in (select customer_no from vx_perf_seat where perf_no in (select perf_no from t_perf where season=58))

Lucie

________________

Lucie Spieler

IT Development and Training Manager

Florida Grand Opera

8390 NW 25th Street

Miami, FL 33122

305-854-1643 ext 1521

www.FGO.org

Hi,

From a generic list of patrons generating by using extracting manager and a season, I would like to remove every patron that has already booked in to a performance (of a 3 week run of a show) in the future.

When I try to do this, I get zero count for that extraction segment.

Am I missing a simple trick or does this require SQL code?

Thank you!

Giles

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