EP3 - WorkView - Undelete Objects - Any reports/reporting available?

[Christian_Jones]

Good day,

Is there a built-in OnBase report available to provide a list of all of the WorkView - Undelete Objects in "EP3 OnBase Studio | WorkView tab | Undelete Objects"  ?

Or is there a Reporting Dashboard or SQL query available

Or another method, i.e. export those Application, Class, Filter lists to excel? 

Are any of these available in EP4, EP5, EP6 or a future release?

Thank you,

Christian

[Bill_Schoby · Accepted solution]

Query hsi.rmObject and look at the field ActiveStatus.

0 = saved object

1 = inactive (created but not saved)

2 = deleted

You also have ObjectName and ClassID in the rmObject table so you can use those to refine your WHERE clause if you are looking for a particular object or class.

This should get you started:

SELECT top 10

c.className, o.*
FROM hsi.rmobject o
INNER JOIN hsi.rmClass c on o.classid = c.classid

WHERE o.activestatus = 2