It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,962
×324

question asked: Oct 23 '19, 5:24 p.m.
question was seen: 1,159 times
last updated: Nov 15 '19, 8:42 a.m.

Related questions

Which snapshot/table holds RQM test case state definitions

0
Hamid Ouaggag (11●4) | asked Oct 23 '19, 5:24 p.m.
I am trying to build a BIRT report of RQM (5.0.1) test cases showing their states (among other columns). While I found most of what I'm looking for in the LIVE_TEST_CASE table of the PLANNING_SNAPSHOT, I need the definitions (id, name) of the test case states, since the TESTCASE_STATE column of the LIVE_TEST_CASE table contains only the state id. I could not find which snapshot/table holds that id-name mapping (similar to the mapping in the LIVE_EXEC_STATE table for the execution states).

Your help will be much appreciated.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Mehul Patel (969●5) | answered Nov 15 '19, 5:59 a.m.
FORUM MODERATOR

 Hamid,


Check TESTCASE_WORKFLOW_STATES, you could use WORKFLOW_STATE_ID and WORKFLOW_STATE_NAME.

Regards,
Mehul

Comments
Hamid Ouaggag commented Nov 15 '19, 8:42 a.m.
Thank you Mehul,
Actually I did check that table before but it is empty! I checked it on several servers. The admins team confirmed that the data collection tasks are running, but that table (and several others) are always empty.

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.