Hi Everyone,
Is there any code or option in the schema to disable audit trial fields to be created on a particular schema? As I know, we can disable it via option "XtkAudit_DataSchema," but this will disable for all schema. Reson to disable this in a particular schema is because this audit trial is creating four fields: @created & @lastModified (datetime), @createdBy-id & @modifiedBy-id (long) and these fields are indexed and are creating a vast database size.
Hence finding a way to disable it in the schema itself and remove these indexes from the schema.
Please let me know if you have done something similar.
I have another solution to find the index from pgSQLand use the SQL command to delete these indexes, but I don't want to use the backend for this operation hence need to find a simple solution.
Views
Replies
Total Likes
Hello @SushantTrimukheD,
if you don't ask explicitly Adobe Campaign to add the audit trail (by adding "<element aggregate="xtk:common:auditTrail" name="auditTrail"/>" in the schema) it won't do it.
Br,
Amine
Views
Replies
Total Likes
Thanks Amine, Let me try and come back to you
Views
Replies
Total Likes
Its Not working Amine, I tried to used this code and recreate the schema but still the fields was created and it was also showing inside Audit log.
Anything else?
Views
Replies
Total Likes