• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 58 views
  • Users 0 members are here
Related

changing who reminders are assigned to

Kathleen Smith
$organization

Hi all, (cross-posting in Development as well)

 

We’ve had some changes in our Development Department, and I’ve been asked to reassign all of one person’s reminders to someone else.  Is there any harm in me running an update statement on tx_sol_task in SQL to swap the solicitor? 

 

Thanks!
Kathleen

 

  • $organization

    Hey Kathleen,

    I'm not sure about the update statement. You may want to open a help ticket to verify that changes aren't required in other tables (the domino effect!).

    But have you looked into leaving the current reminders where they are and setting up the new user as the Reminder Proxy Userid in Preferences. That way you aren't messing with the tables and the new user can see all of those reminders plus any new ones assigned to them.

    Beth

  • $organization

    How could I have forgotten about that?!  That’ll do- much better than the sledgehammer approach ;-) 

     

    Thanks a bunch! 

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Thursday, August 27, 2015 12:52 PM
    To: Kathleen Smith
    Subject: Re: [Tessitura Technical Forum] changing who reminders are assigned to

     

    Hey Kathleen,

    I'm not sure about the update statement. You may want to open a help ticket to verify that changes aren't required in other tables (the domino effect!).

    But have you looked into leaving the current reminders where they are and setting up the new user as the Reminder Proxy Userid in Preferences. That way you aren't messing with the tables and the new user can see all of those reminders plus any new ones assigned to them.

    Beth

    From: Kathleen Smith <bounce-kathleensmith6726@tessituranetwork.com>
    Sent: 8/27/2015 4:21:05 PM

    Hi all, (cross-posting in Development as well)

     

    We’ve had some changes in our Development Department, and I’ve been asked to reassign all of one person’s reminders to someone else.  Is there any harm in me running an update statement on tx_sol_task in SQL to swap the solicitor? 

     

    Thanks!
    Kathleen

     




    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!