Activity Log

Questions about and code samples for custom order rules and validation within Select.
Post Reply
rhamaoui
Posts: 4
Joined: Sat Nov 05, 2022 10:51 pm

Activity Log

Post by rhamaoui »

I'd like to track any changes made to any file.

I know that I can subscribe to events in SoftPro, but are those events also logged somewhere in the database? Meaning if for whatever reason my event listener is not called when the event happens, I'd like to be able to check a table with the timestamp of the last event I did catch so that I can grab any events that occurred afterwards that I may have missed.

I'm hoping there is such a table because otherwise I'm going to have to monitor the SQL Server Transaction Log and try to make sense of the transactions that I need to care about.
BobRichards
Posts: 1376
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Activity Log

Post by BobRichards »

What type of events? Just order saves or transaction register changes? If you monitor every SQL transaction the drag will be huge! Also, we do not save every change to every possible object that Select makes to the database. I need more information on what you are trying to achieve.
Bob Richards, Senior Software Developer, SoftPro
Post Reply