How to insert data in AuditBase table

(0) Share

Report

Posted on by Community Member

I am having requirement to update null value to Contact entity form field, But it should show in audit log. How can i achieve this, if i update null in database means the audit history in that record also updated to null, any possibility to do this?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Kokulan 18,054 on at

Like (0)

Report

Could you clarify the following please? You would like to update a field on contact entity with null value but don't want this change to be shown in the Audit History?

Was this reply helpful? Yes No
Suggested answer

Charles Abi Khirs 3,569 on at

Like (0)

Report

Hello,

You have to enable auditing in order to see those changes.

1. Enable global audit on the organization level (Settings > Audit)

2. Enable the audit on the entity level (contact in your case)

3. Enable the audit on the field level

Once all is done and the desired field where you enabled the audit is changed in the form, you can see the audit logs in the related relations of the record even for the null values

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Kokulan , exactly i have one option set in contact entity when ever this field change to Clear option in that option set my plugin will trigger and update the database to null for that field. But i don't want it to reflect on Audit History, if i update that field value to null means audit history also showing as null. How to keep this update only in entity level.

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

Updating CRM database is highly unsupported.

Enable Auditing on Contact entity and that particular field, Then it will appear in Audit history.

Below post will show you that how to enable Auditing:

crmbook.powerobjects.com/.../auditing-in-microsoft-dynamics-crm

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i am using On premises version so update to database data is supported, its unsupported only for online version.

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

You can not update Database of Online as you don't know where it is stored.

In on premise, you have database on your server and you are not suppose to update database of CRM on premise. It is UNSUPPORTED.

Was this reply helpful? Yes No