• Registered: 2023-01-06
  • Posts: 5

Topic: LOGGING FEATURE

Good day everyone!

I'd like to ask if MVD has a logging feature that records all the transactions in the system. Like who or which user that made the changes in the database from login to CRUD transactions. Thank you.

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 417

Re: LOGGING FEATURE

jayvallejera wrote:

Good day everyone!

I'd like to ask if MVD has a logging feature that records all the transactions in the system. Like who or which user that made the changes in the database from login to CRUD transactions. Thank you.

I think there is none, you need to create your own logic for this.

brian
  • Registered: 2014-06-25
  • Posts: 863

Re: LOGGING FEATURE

I do it with triggers using a database admin tool, there is no tool in MVD to create triggers.

  • k245
  • k245
  • Member
  • Offline
  • From: Deep
  • Registered: 2017-10-12
  • Posts: 1,538

Re: LOGGING FEATURE

https://myvisualdatabase.com/forum/view … hp?id=3642

Визуальное программирование: блог и телеграм-канал.

k245's Website

5 Reply by tcoton (edited by tcoton 2024-02-27 15:40:40)

  • Registered: 2014-06-25
  • Posts: 863

Re: LOGGING FEATURE

k245 wrote:

https://myvisualdatabase.com/forum/view … hp?id=3642

While this is an easy way to create triggers, it is also a weird one, since they are rebuilt every time the form is shown and the code is exposed in the script file, hence why I prefer to use a database admin tool to create them.

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,675

Re: LOGGING FEATURE

I guess it's also possible, instead of using triggers,  to write a script to also log changes to whatever fields you need to audit (not all fields are critical).
Please see attached as a simple example.
Derek.

Post's attachments

Attachment icon audit v2.zip 443.58 kb, 37 downloads since 2024-02-27 

  • Registered: 2014-06-25
  • Posts: 863

Re: LOGGING FEATURE

Nice one Derek, it is quite a bit of code though smile