MySQL track changes on creation/ modification of application or docType

Hello Team,

We want to track the changes at database level after creation of applications or docType, etc

I have run following command,

select * from sys.objects
where type = 'U' or type = 'P'
and modify_date between '2018-08-01' and '2018-08-07' 

Error:

ERROR 1142 (42000): SELECT command denied to user ‘d82b359407’@‘localhost’ for table ‘objects’

  1. Do we have any other solution to track the changes?

You can use build-in versioning feature.

If Versioning is enabled for particular doctype, on value change system logs the changes ie old value, new value and the user

Hello @saurabh6790,

Sure, we will implement versioning.

Our moto behind question is as follow:

To understand

  1. New application entry → (tabModule Def), right ?
  2. How ERP manage database/ column versioning?

@saurabh6790 - Is it possible to get versioning on a custom field? I’ve seen the versioning on standard fields but not on custom fields. How does one go about this?

@saurabh6790 - have you managed to look at the question I posed above?