It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,907
×5,996
×1,235

question asked: Oct 07 '14, 2:50 p.m.
question was seen: 2,977 times
last updated: Oct 07 '14, 3:24 p.m.

Related questions

FAQ - How this Forum works

how do I get the issoftdeleted flag in Insight reports?

0
1
David Mehaffy (901●2●32●38) | asked Oct 07 '14, 2:50 p.m.
JAZZ DEVELOPER
 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

2
permanent link
Jackie Albert (1.6k●1●49●46) | 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
Comments
David Mehaffy commented Oct 07 '14, 3:24 p.m.
JAZZ DEVELOPER

Thanks Jackie - that did the trick 

Your answer

Register or to post 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.