Skip to main content
Answer

Can we record Audit History when doing direct DB Updates

  • April 27, 2022
  • 1 reply
  • 83 views

Forum|alt.badge.img

Hello, we need help in recording Audit History when doing direct DB Updates, for some reason we are doing direct DB Updates to one screen, the data is updating correctly but that is not getting recorded in Audit history, do we have any other way to record audit history even if we are doing direct DB Updates.

 

PXDatabase.Update<TableName>((PXDataFieldParam)new PXDataFieldAssign(“FieldName”, “FieldValue”),
(PXDataFieldParam)new PXDataFieldRestrict("TableId", TableId));

Best answer by Naveen Boga

Hi @ckwiat46  Direct DB updates will not log any details on the Audit History.

I don’t think we have a workaround to store the details in the Audit History when we do direct DB updates.

1 reply

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • April 27, 2022

Hi @ckwiat46  Direct DB updates will not log any details on the Audit History.

I don’t think we have a workaround to store the details in the Audit History when we do direct DB updates.