09-06-22 08:44 AM
Answered! Go to Answer.
09-06-22 12:52 PM
SELECT [eventdatetime]
,[sNarrative]
,[gTgtProcID]
,[comments]
,[EditSummary]
,[oldXML]
,[newXML]
FROM [blueprism].[dbo].[BPAAuditEvents] INNER JOIN [blueprism].[dbo].[BPAProcess]
ON [blueprism].[dbo].[BPAAuditEvents].gTgtProcID = [blueprism].[dbo].[BPAProcess].processid
WHERE [newXML] IS NOT NULL AND [blueprism].[dbo].[BPAProcess].name = 'Order System - Enter Order'
ORDER BY [eventdatetime] DESC
09-06-22 09:53 AM
09-06-22 10:37 AM
09-06-22 10:42 AM
09-06-22 12:52 PM
SELECT [eventdatetime]
,[sNarrative]
,[gTgtProcID]
,[comments]
,[EditSummary]
,[oldXML]
,[newXML]
FROM [blueprism].[dbo].[BPAAuditEvents] INNER JOIN [blueprism].[dbo].[BPAProcess]
ON [blueprism].[dbo].[BPAAuditEvents].gTgtProcID = [blueprism].[dbo].[BPAProcess].processid
WHERE [newXML] IS NOT NULL AND [blueprism].[dbo].[BPAProcess].name = 'Order System - Enter Order'
ORDER BY [eventdatetime] DESC