Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Disable Audit Trial for One Schema

Avatar

Level 2

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.


3 Replies

Avatar

Level 4

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

Avatar

Level 2

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?