It's all about the answers!

Ask a question

Putting the date in a field instead of history

Mahari Hill (4861161230) | asked Nov 20 '17, 12:23 p.m.
edited Nov 20 '17, 2:14 p.m. by Fariz Saracevic (904613)

CLM 602, (soon 604)


In ClearQuest, when we moved between workflow states, we added a date and a perl script:

New State / Date New
Assigned State / Date Assigned
Closed State / Date Closed.

Which was good for querying and excel reports. Also, for management who just wanted a view of when work moved to a specific date, or through it.

  1. In RTC, is there an example someone made for me getting the dates in to a field instead of history?
  2. In 604, it seems i can report on dates of status changes, but how do you show in table format
    • id, date new, date assigned, ...., date closed
    • id, date new, date assigned, ...., date closed

Fariz Saracevic commented Nov 20 '17, 2:16 p.m.

Hi Mahari,

How is your question related to JRS? If it is not, please do not use tags that are not related to your question.

Amy Silberbauer commented Nov 20 '17, 3:27 p.m. | edited Nov 20 '17, 3:27 p.m.

I'm not exactly sure what your question is, but since you mentioned "report" in (2) above, are you asking for something like this?


Mahari Hill commented Nov 21 '17, 7:35 a.m.

Hello Amy,

This is exactly what I am seeking. Is there a certain version that I have to be on to get the report you have above? Are you designating the "state/dates" to show in the report or is it "automagically" showing the columns as it finds dates for those states?


Be the first one to answer this question!

Register or to post your answer.