Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
Topic Title: CR Status Change
Topic Summary: Status Change
Created On: 30-Jun-2005 20:24
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 30-Jun-2005 20:24
User is offline View Users Profile Print this message


Diego Cancel

Posts: 16
Joined: 18-Feb-2004

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.
Report this to a Moderator Report this to a Moderator
 1-Jul-2005 16:46
User is offline View Users Profile Print this message


Stefan Oblinger

Posts: 5
Joined: 31-Jul-2004

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
Report this to a Moderator Report this to a Moderator
 12-Jul-2005 04:34
User is offline View Users Profile Print this message


Diego Cancel

Posts: 16
Joined: 18-Feb-2004

Sorry but where is this log at "transition_log" I have look for it without any luck.
Report this to a Moderator Report this to a Moderator
 12-Jul-2005 12:14
User is offline View Users Profile Print this message


Stefan Oblinger

Posts: 5
Joined: 31-Jul-2004

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')
Report this to a Moderator Report this to a Moderator
 15-Jul-2005 20:52
User is offline View Users Profile Print this message


Diego Cancel

Posts: 16
Joined: 18-Feb-2004

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.
Report this to a Moderator Report this to a Moderator
 21-Jul-2005 09:40
User is offline View Users Profile Print this message


Arjan Schuurmans

Posts: 1
Joined: 3-May-2004

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.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.