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

Finding what records were updated by a user

Barbara Pinney
$organization

I'm looking for a way to find every record added or updated by a certain Tessitura user -- I don't need the level of detail found in the Constituent audit report, just be able to specify a user(s) name and get a list of constituent records they "touched" so I can add a constituency to the list.

tessuser01:

  • 11111111
  • 33333333
  • 78787878

Thanks,

Barbara Pinney

Tulsa Arts Management Consortium

 

 

Parents
  • Former Member
    Former Member $organization

    Hi Barbara,

    You could set up a list element to look at the last_updated_by column in T_CUSTOMER. I can't remember the full list of actions that triggers an update to that field, but definitely when the record is added.  And I believe it also updates when any information on the general tab is changed and when a transaction is saved to the customer.

    The only short coming to this is that the very next time someone touches the record, you will lose the value.  So you'd want to run your lists at key moments in the day.

    - Levi

Reply
  • Former Member
    Former Member $organization

    Hi Barbara,

    You could set up a list element to look at the last_updated_by column in T_CUSTOMER. I can't remember the full list of actions that triggers an update to that field, but definitely when the record is added.  And I believe it also updates when any information on the general tab is changed and when a transaction is saved to the customer.

    The only short coming to this is that the very next time someone touches the record, you will lose the value.  So you'd want to run your lists at key moments in the day.

    - Levi

Children
No Data