Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

how do I get the issoftdeleted flag in Insight reports?

Questions
Tags
Users
Badges
David Mehaffy
JAZZ DEVELOPER (901●2●33●38) 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.

1

0 votes

1 answer
3,375 views
0 votes

Accepted answer

Permanent link
Jackie Albert
(1.6k●1●49●47) 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

2 votes

Comments
David Mehaffy
JAZZ DEVELOPER Oct 07 '14, 3:24 p.m.

Thanks Jackie - that did the trick 

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 07 '14, 2:50 p.m.

Question was seen: 3,375 times

Last updated: Oct 07 '14, 3:24 p.m.

Confirmation Cancel Confirm