It's all about the answers!

Ask a question

how do I get the issoftdeleted flag in Insight reports?

David Mehaffy (90122736) | asked Oct 07 '14, 2:50 p.m.
 We are trying to generate an Insight report for the soft deleted TCERs that we have in our RQM repository.  Is deleted from the exec_workitem table in ODS always returns 0 but if I do a db2 query directly on the riods.exec_workitem table or the vw_exec_workitem view from the data warehouse I have approximately 9600 rows where issoftdeleted = 1.  Is this a bug with Insight? I note that this value is a small int vs an int.  The data looks like it is in the data warehouse but Insight queries are not able to pull the data.  I am stumped.

Accepted answer

permanent link
Jackie Albert (1.6k14744) | answered Oct 07 '14, 2:55 p.m.

Hi Dave,

You might want to check the Framework Manager settings.  In the 'Parameter Maps', there is a Parameter called "Show Deleted Records" for which I believe the default is to keep them hidden.  If you switch this and re-publish the FM model, this should allow them to show up in your reports.

Hope this helps!

David Mehaffy selected this answer as the correct answer

David Mehaffy commented Oct 07 '14, 3:24 p.m.

Thanks Jackie - that did the trickĀ 

Your answer

Register or to post your answer.