It's all about the answers!

Ask a question

How to map state id with state name?


Vijay Kumar Ravishankar (3642) | asked Jul 02 '09, 7:16 p.m.
Hi,

I am using LIVE_WORKITEM_CNT table and the column "State_Name" contains only numbers like 1,2,3... and so on. How do i map these numbers with states such as new, closed etc.


Thanks
Vijay

3 answers



permanent link
Lorelei Ngooi (1.5k22) | answered Jul 06 '09, 1:36 p.m.
JAZZ DEVELOPER
Is this question being asked in the context of using the ClearQuest connector, Bugzilla importer, or something else?

permanent link
Vijay Kumar Ravishankar (3642) | answered Jul 06 '09, 1:51 p.m.
Is this question being asked in the context of using the ClearQuest connector, Bugzilla importer, or something else?



No, I just wanted to create a report using that data set. How to map state name with state ids

permanent link
Marcel Bihr, Jazz Work Item team (1.4k) | answered Jul 08 '09, 3:54 a.m.
JAZZ DEVELOPER
Hi
You can use IWorkItemCommon#findWorkflowInfo to retrieve a IWorkflowInfo and on that 'getStateName(Identifier state)' will give you the name of the workflow state.
You need the actual work item to retrieve the matching WorkflowInfo.

Regards

Marcel
Jazz Work Item team

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.