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: Query
Topic Summary: ChangeSynergy Query
Created On: 11-Oct-2006 09:22
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.
 11-Oct-2006 09:22
User is offline View Users Profile Print this message


Mattias Johansson

Posts: 14
Joined: 5-Jul-2004

Is there anyone who knows if there is a way to query for a Change Request of an arbitrary status, which have all associated tasks completed?
Thanks,
Mattias
Report this to a Moderator Report this to a Moderator
 26-Oct-2006 14:56
User is offline View Users Profile Print this message


michael Barnes

Posts: 85
Joined: 12-Nov-2003

use the "has_associated_task" function.

If you want to exclude CRs that have no tasks, then include "has_associated_task(cvtype='task')"

The following query should do what you are asking for:

    (cvtype='problem') and has_associated_task(cvtype='task') and not has_associated_task(status!='completed')


However, there are other task states that you might want to include in your query. For example "excluded". What you probably want is CRs where there is at least one task and there is no task in the registered or assigned states.
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.