How to get the details of record from the sys_audit_delete

[panda1]

I want to restore some deleted incident's records

Conditions like this

if delete date < xxxx  and record.state < 4

sys_audit_delete，I observed this table, and it seems that the record of incident has become XML

I want to read the value of the state field from it,Are there any APIs like GlideRecord?

Or I need to parse XML？

[Maik Skoddow · Accepted solution]

Hi

you are right: the contents of the records in that table are stored in XML format. This is the only way to capture deleted records.

But you still can use a simple lookup with the OOTB filter conditions. There is a column "Record deleted" you can use and for the "state" lookup you have to search for each value individually (but you can combine them in a OR condition):

Maik