tdietrich
12/08/2020, 6:07 PMSELECT
Date,
RecordTypeID,
BUILTIN.DF( RecordTypeID ) AS RecordType,
RecordID,
Field,
OldValue,
NewValue,
Name As EmployeeID,
BUILTIN.DF( Name ) AS EmployeeName,
Role,
BUILTIN.DF( Role ) AS RoleName,
Context,
BUILTIN.DF( Context ) AS ContextName
FROM
SystemNote
WHERE
Field = 'TRANDOC.KSTATUS'
AND ROWNUM <=10
ORDER BY
Date ASC