• Replies 1 reply
  • Subscribers 338 subscribers
  • Views 28 views
  • Users 0 members are here
Related

Ticket and Subscription History

Reena Taank
$organization

Hi All,

We are wondering if there is a way to transfer ticket history to a patron who splits up their account.  For example, Mrs Smith has purchased subscriptions for 2 of her friends for 10 years. This year however, they choose to split up their subscriptions into their own accounts. 

We are starting to do more and more work to honour long time subscribers and unfortunately this info is lost when creating new accounts.  Any ideas? Does anybody have a workaround on this?

Thanks

Reena

  • $organization

    Hi Reena, We are using the old ticket history tables (t_tck_hist and t_subscription_hist).There's nothing you can do through the interface with those, but you certainly run a sql statement to move the data.

    Here is a sample script. It will work best for completed seasons.

    declare @move_from_cno int, @move_to_cno int, @season int

    select @move_from_cno = 1001, @move_to_cno = 100001

    update dbo.T_SUBSCRIPTION_HIST set customer_no = @move_to_cno where season = @season and customer_no = @move_from_cno

    Matt