how do I get the issoftdeleted flag in Insight reports?
![]()
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
![]() 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
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.