Hi Community,
I need to create a report showing all the failed jobs within the past week. I was able to successfully do that however when a user goes in and deleted their failed instance, it does not remove that instance from the webi report.
How can I accomplish this? Creating a report for failed jobs that can track deleted ones as well. And to clarify, not deleted reports in the whole environment, just deleted failed instances.
Thanks in Advance
MHassan (BOB member since 2013-11-19)
You would need to do a subquery, in which you exclude object CUIDs that are associated with a “Delete” event.
joepeters 
(BOB member since 2002-08-29)
Can you assist on how that can be done?
Which object would provide me with that information?
I figured some sort of flag will need to be used to filter out reports in public folders. CUID can be a flag?
MHassan (BOB member since 2013-11-19)
Your query should look like the following:
joepeters (BOB member since 2002-08-29)
Hmm,
Im not able to get my where clause they way you have it, or “InList” the same object either.
any idea?
MHassan (BOB member since 2013-11-19)
It’s a subquery. The icon to create it is at the top of the Query Filters pane.
joepeters (BOB member since 2002-08-29)
Thanks so much!
Im able to populate the report and show which deletions occurred by using the object ID as the flag.
MHassan (BOB member since 2013-11-19)