• Replies 6 replies
  • Subscribers 337 subscribers
  • Views 116 views
  • Users 0 members are here
Related

TR_SPECIAL_ACTIVITY rollback?

Tiffany Elliott (Past Member)
$organization

Hi everyone!

I'm hoping someone will have some guidance on how to fix an error created by the Manage Special Activity Utility.

Someone recently utilized the Manage Special Activity utility but unfortunately used an incorrect List of patrons and created incorrect data for the wrong people. The activity is a way for our development staff to track specific committee/board meetings. They were able to update the activity to imply that the 'event' was cancelled, which was a quick fix, but we'd like for the individuals who received this event in error to have that table updated.

How would one go about fixing this?

I'm still learning some SQL, but the only thing I can see is the table TR_SPECIAL_ACTIVITY and I know the ID of the activity we want to take away and I know the List No of the individuals who incorrectly updated.  The problem is, I only want to delete the entry that was created for the incorrect list at that moment... not delete the activity from the table altogether. That's where I'm stuck.

When I look at the data object:  RP_GLOBAL_ACTIVITY_INSERT_UPDATE, it says the mode must be in "I" or "U" (insert or Update), no "D" (delete/drop) option. :-(

Does anyone have any suggestions how to delete this insert made in error before I head to our support people and bother them?  :) 

 

Thanks,

Tiffany Evans

Database Coordinator

Huntington Theatre Company

Boston, MA

Parents
  • $organization

    Oh! 

    That was super easy.

     

    Thank you for your help, Renville!! J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Renville Williams
    Sent: Tuesday, October 08, 2013 2:16 PM
    To: Tiffany Evans
    Subject: Re: [Tessitura Technical Forum] TR_SPECIAL_ACTIVITY rollback?

     

    Well to delete from that table it would be:

     

    Delete sa

    From T_SPECIAL_ACTIVITY sa

    JOIN T_LIST_CONTENTS lc on sa.customer_no = lc.customer_no

    Where sp_act IN (<special_act_number>)

    AND lc.list_no IN (<list_no>)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 10/8/2013 12:34:55 PM

    Hi everyone!

    I'm hoping someone will have some guidance on how to fix an error created by the Manage Special Activity Utility.

    Someone recently utilized the Manage Special Activity utility but unfortunately used an incorrect List of patrons and created incorrect data for the wrong people. The activity is a way for our development staff to track specific committee/board meetings. They were able to update the activity to imply that the 'event' was cancelled, which was a quick fix, but we'd like for the individuals who received this event in error to have that table updated.

    How would one go about fixing this?

    I'm still learning some SQL, but the only thing I can see is the table TR_SPECIAL_ACTIVITY and I know the ID of the activity we want to take away and I know the List No of the individuals who incorrectly updated.  The problem is, I only want to delete the entry that was created for the incorrect list at that moment... not delete the activity from the table altogether. That's where I'm stuck.

    When I look at the data object:  RP_GLOBAL_ACTIVITY_INSERT_UPDATE, it says the mode must be in "I" or "U" (insert or Update), no "D" (delete/drop) option. :-(

    Does anyone have any suggestions how to delete this insert made in error before I head to our support people and bother them?  :) 

     

    Thanks,

    Tiffany Evans

    Database Coordinator

    Huntington Theatre Company

    Boston, MA




    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!

Reply
  • $organization

    Oh! 

    That was super easy.

     

    Thank you for your help, Renville!! J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Renville Williams
    Sent: Tuesday, October 08, 2013 2:16 PM
    To: Tiffany Evans
    Subject: Re: [Tessitura Technical Forum] TR_SPECIAL_ACTIVITY rollback?

     

    Well to delete from that table it would be:

     

    Delete sa

    From T_SPECIAL_ACTIVITY sa

    JOIN T_LIST_CONTENTS lc on sa.customer_no = lc.customer_no

    Where sp_act IN (<special_act_number>)

    AND lc.list_no IN (<list_no>)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 10/8/2013 12:34:55 PM

    Hi everyone!

    I'm hoping someone will have some guidance on how to fix an error created by the Manage Special Activity Utility.

    Someone recently utilized the Manage Special Activity utility but unfortunately used an incorrect List of patrons and created incorrect data for the wrong people. The activity is a way for our development staff to track specific committee/board meetings. They were able to update the activity to imply that the 'event' was cancelled, which was a quick fix, but we'd like for the individuals who received this event in error to have that table updated.

    How would one go about fixing this?

    I'm still learning some SQL, but the only thing I can see is the table TR_SPECIAL_ACTIVITY and I know the ID of the activity we want to take away and I know the List No of the individuals who incorrectly updated.  The problem is, I only want to delete the entry that was created for the incorrect list at that moment... not delete the activity from the table altogether. That's where I'm stuck.

    When I look at the data object:  RP_GLOBAL_ACTIVITY_INSERT_UPDATE, it says the mode must be in "I" or "U" (insert or Update), no "D" (delete/drop) option. :-(

    Does anyone have any suggestions how to delete this insert made in error before I head to our support people and bother them?  :) 

     

    Thanks,

    Tiffany Evans

    Database Coordinator

    Huntington Theatre Company

    Boston, MA




    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!

Children
No Data