Friday, 2 October 2015

Select Audit Data from Database

Have you seen this when you select data from Audit table in Acumatica?

Acumatica stores all audit in one table Audit History. Keys and Changed fields are saved to database in combined mode. Data is concatenated with symbol \0, thats why you are not able to read this fields with just normal SQL server management studio.

To resolve it, you can replace special symbol just with normal colon. Use this script:

No comments: