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’
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
New application entry → (tabModule Def), right ?
How ERP manage database/ column versioning?
Eli
August 8, 2018, 9:48am
4
@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?
Eli
August 10, 2018, 12:25pm
5
@saurabh6790 - have you managed to look at the question I posed above?