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

How Can I get the normal state name when I select the Live_WorkItem_Cnt in the WorkItems Snapshot.

Questions
Tags
Users
Badges
YuanYou Yin
(23●8) Jun 01 '18, 5:05 a.m.

 I have made a report by BIRT.When I display it,the name of series is the type of "...".

example:"com.ibm.team.apt.epic.workflow.state.s1"
The state_name is from the Live_WorkItem_Cnt  in the WorkItems Snapshot.

And when the state_name if from the WorkItem_States in the WorkItems Snapshot,it is normal.
example:"new"

How Can I get the normal state names when I select the Live_WorkItem_Cnt  in the WorkItems Snapshot.

The following link is the information about state name.

version of RTC: 6.0.2
type of client:Eclipse 3.6.x& Web(IE 8)
operating system:Windows 7
version of BIRT :2.6.2

0 votes

1 answer
1,764 views
0 votes

One answer

Permanent link
Bill Taylor
(144●15●35) Oct 05 '18, 1:42 p.m.
The WORKITM_SNAPHOT table STATE has two relevant fields: STATE and STATE_NAME

STATE is the catenation of the "Project Area itemId", the letter "s" and the simple id of the state.

STATE_NAME will give you the name of the state

0 votes

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
× 10,940

Question asked: Jun 01 '18, 5:05 a.m.

Question was seen: 1,764 times

Last updated: Oct 05 '18, 1:42 p.m.

Confirmation Cancel Confirm