Skip to main content
Solved

Can we record Audit History when doing direct DB Updates

  • Apr 27, 2022 11:06 AM UTC
  • 1 reply
  • 107 views
  • Translate All

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.

View original

1 reply

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Apr 27, 2022 11:19 AM UTC

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.

Translate