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:
Thanks,
Barbara Pinney
Tulsa Arts Management Consortium
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
Thank you for the responses – I appreciate it!
TAMC