How do I detect what user made a change on a given record?

This forum is for programmers who have questions about the source code.
Post Reply
gharris
Posts: 3
Joined: Thu Jun 21, 2018 1:34 pm

How do I detect what user made a change on a given record?

Post by gharris » Thu Jun 21, 2018 1:55 pm

We are working on a plugin that syncs some of the Open Dental tables with another system. One of the pieces of data that we were hoping to capture was when a record on any of these tables is updated by an OD user, who made that change and when?

I can see that many tables have a column for SecDateTEdit which appears to be updated per edit, however the usernum of the editing user is not tracked. Is there another way to achieve this?

Thanks

JoeMontano
Posts: 64
Joined: Thu Aug 20, 2015 11:08 am

Re: How do I detect what user made a change on a given recor

Post by JoeMontano » Thu Jun 21, 2018 2:05 pm

Tough to say. Would have a better idea if we had a list of the tables you need.
Joe Montaño
Software Engineer
Open Dental Software
Joe@OpenDental.com

gharris
Posts: 3
Joined: Thu Jun 21, 2018 1:34 pm

Re: How do I detect what user made a change on a given recor

Post by gharris » Thu Jun 21, 2018 2:27 pm

I guess in a way that answers my question, as we were hoping to find same common logging convention that tables followed. If the data does exist, but is somewhat custom per table or genre of table, than it probably will not work the way we were hoping. Some of the tables i know we will be grabbing:

carriers
claim (and many of the other claim tables)
patient (and many of the other patient tables)
procedure tables
treatplan

JoeMontano
Posts: 64
Joined: Thu Aug 20, 2015 11:08 am

Re: How do I detect what user made a change on a given recor

Post by JoeMontano » Thu Jun 21, 2018 3:35 pm

Hmm if I understand your best bet would be to reference the securitylog table. But I don't think it will be bullet proofs.
Joe Montaño
Software Engineer
Open Dental Software
Joe@OpenDental.com

gharris
Posts: 3
Joined: Thu Jun 21, 2018 1:34 pm

Re: How do I detect what user made a change on a given recor

Post by gharris » Fri Jun 22, 2018 8:43 am

It looks like you're right. While it does appear to contain the information we want, its not in a format we can use in the way we intended. Thanks for getting back to me though.

Post Reply