![]() |
Telelogic SYNERGY (steve huntington) | ![]() |
Topic Title: CR Status Change Topic Summary: Status Change Created On: 30-Jun-2005 20:24 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I am trying to find out a query so I can check any CR that has chnage status in the last hour or so. Any ideas I am lost.
|
|
![]() |
|
![]() |
|
The generic solution would analyse the transition_log attribute of all CRs that were modified during the last hour. A simple script would be necessary to accomplish this. Nevertheless a query-only solution is possible, but as a drawback it depends on your CR lifecycle definition:
ccm query "type='problem' and (entry_date>time('-0:1:0:0') or verification_date>time('-0:1:0:0') or assignment_date>time('-0:1:0:0') or resolution_date>time('-0:1:0:0') or conclusion_date>time('-0:1:0:0') or obsolete_time>time('-0:1:0:0') or reject_time>time('-0:1:0:0') or duplicate_time>time('-0:1:0:0') or deferred_time>time('-0:1:0:0'))" -f "%displayname %transition_log " Edited: 1-Jul-2005 at 16:49 by Stefan Oblinger |
|
![]() |
|
![]() |
|
Sorry but where is this log at "transition_log" I have look for it without any luck.
|
|
![]() |
|
![]() |
|
In the uncustomized ChangeSynergy GUI the Transition Log is labeled as "Log:". The query that i presented in my answer was intended to be executed on the command line interface. Of course you may execute the query via ChangeSynergy GUI, too. Simply execute the following custom query:
entry_date>time('-0:1:0:0') or verification_date>time('-0:1:0:0') or assignment_date>time('-0:1:0:0') or resolution_date>time('-0:1:0:0') or conclusion_date>time('-0:1:0:0') or obsolete_time>time('-0:1:0:0') or reject_time>time('-0:1:0:0') or duplicate_time>time('-0:1:0:0') or deferred_time>time('-0:1:0:0') |
|
![]() |
|
![]() |
|
Stefan I really appreciate your help on this. I have one more question: I still don't get the last CRs but teh ones for the complete day. I have tried all combinations on where to put the 1 with no luck. Any ideas.
|
|
![]() |
|
![]() |
|
Hello Diego,
why don't you try Last Modified Time? for example: modify_time>time('%today_minus1days') shows all events that changed the last day. A disadvantage is that is also show events that had another attribute changed. |
|
![]() |
Telelogic SYNERGY
» SYNERGY/Change
»
CR Status Change
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.