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: Using Query to find Problems with no associated tasks
Topic Summary: CS Query
Created On: 30-Mar-2005 20:16
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-Mar-2005 20:16
User is offline View Users Profile Print this message


Kristan Hatch

Posts: 8
Joined: 4-Sep-2003

HI,

I am trying to create a query that will display all problems that do not have a task associated to them. I have used the following, but they are not working correctly:

(cvtype='problem') and ((resolver='klhatch') and (crstatus='dev') and (is_no_associated_cv()))

and

(cvtype='problem') and ((resolver='klhatch') and (crstatus='dev') and (not has_associated_cv(cvtype!='problem')))

Any suggestions?

Thanks so much!
Report this to a Moderator Report this to a Moderator
 31-Mar-2005 05:38
User is offline View Users Profile Print this message


Vincent Gaudeul

Posts: 68
Joined: 10-Oct-2002

The relation between Change Requests and Tasks is called associated_task.

For your information, this relation is set up as a CCM_RELATION attribute in any SYNERGY/Change CRProcess XML files.

So the following query will give you good results:

cvtype='problem' and not has_associated_task(cvtype='task')

associated_cv is the name of the relation SYNERGY manages between tasks and object versions (at check-out).

Regards

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.