Is there any way to pull a list of records where addresses have been updated/changed within a certain time period? The box office has been printing a lot of tickets during pandemic and we want to pull tickets with address changes before mailing. The only thing I can find is output date of last record change, but that will be a lot more time consuming than pulling specific for address updates.
Thank in advance!!
Jen
Hi Jen - have you tried the Constituent Audit Report? You can filter by date / table (t_address) and by list. Once run , you could export as csv to get to the updated records only.
Thank you! It's over 700 pages using the T_Address, but I'm now thinking maybe I can merge it with a list of printed tickets and narrow it down.
I wish I had know about this a year ago. Back then I wrote a SQL statement that looked at TA_AUDIT_TRAIL. It did what I needed it to do, but I sure wish I had found this report first.
Ashley