It's all about the answers!

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

×42,874

question asked: Feb 17 '10, 7:17 a.m.
question was seen: 5,094 times
last updated: Feb 17 '10, 7:17 a.m.

Related questions

DAY_ID.TIMESTAMP not avaiable in 2.0.0.2?

0
Bharath M (546●54●28) | asked Feb 17 '10, 7:17 a.m.
Hi,

I developed a report from WORKITEM_CHNGS table on RTC 2.0. We have upgraded to 2.0.0.2 and now when I try to run the report it throws an error saying "Column binding "DAY_ID.TIMESTAMP" has referred to a data set column "DAY_ID.TIMESTAMP" which does not exist".

I checked the design file and tried to edit the data set and now I dont see "DAY_ID.TIMESTAMP" in the avaialable columns.

Any clue?

Thanks,
Bharath

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Feb 17 '10, 5:46 p.m.
JAZZ DEVELOPER
Hi Bharath,

Sorry for the inconvenience, The DAY_ID field was only supposed to be used by the two views WORKITEM_CHNGS_TO and WORKITEM_CHNGS_FROM to count the number of changes during a day. The DAY_ID value can be extracted using very simple math from the TIME_ID value.

Rafik Jaouani
0
permanent link
Bharath M (546●54●28) | answered Feb 17 '10, 10:04 p.m.
Hi Bharath,

Sorry for the inconvenience, The DAY_ID field was only supposed to be used by the two views WORKITEM_CHNGS_TO and WORKITEM_CHNGS_FROM to count the number of changes during a day. The DAY_ID value can be extracted using very simple math from the TIME_ID value.

Rafik Jaouani


Ok. But it was there in 2.0 for WORKITEM_CHNGS right? I have the similar purpose of displaying count of Workitems on a crosstab, for example, that are reopened on a particular day. With TIME_ID it displays a new row for each reopened WI. Please suggest a work around.

--Bharath
0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Feb 18 '10, 1:01 p.m.
JAZZ DEVELOPER
Fetch TIME_ID.TIMESTAMP and add a computed column that computes the day out of the timestamp and use it the same way you were using DAY_ID.TIMESTAMP.

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.