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.

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

Re: LOGGING FEATURE

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

Re: LOGGING FEATURE

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

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

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

Re: LOGGING FEATURE

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.

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, 53 downloads since 2024-02-27 

Re: LOGGING FEATURE

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