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 for task wiht no CR associated
Topic Summary:
Created On: 14-Sep-2005 14:05
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.
Answer This question was answered by Manuel Fernando Rivera, on Monday, October 17, 2005 12:37 PM

Answer:
Hello,

Finally I used the query bellow:

(cvtype='task') and (not is_associated_task_of(cvtype='problem')) and (resolver='%username') and (status!='task_automatic')

Thanks for Kristan and Nick.
 14-Sep-2005 14:05
User is offline View Users Profile Print this message


Manuel Fernando Rivera

Posts: 16
Joined: 26-May-2004


Hello,

I need a query for show all tasks without CRs. I only need a report with tasks with no asociated problems, not any tasks ordered by associated CRs.

I generated a report of tasks with associated CRs, in this report I show all tasks and it's easy to see if there are some CR associated to a task, but when we have a lot of tasks it's hard to notice.

Thanks in advance.

Manuel
Report this to a Moderator Report this to a Moderator
 19-Sep-2005 23:44
User is offline View Users Profile Print this message


Kristan Hatch

Posts: 8
Joined: 4-Sep-2003

Here is the syntax that I used in Change Synergy. I am sure that you can run it from the command line, as well.

(not has_associated_task(cvtype='task') and (resolver='klhatch') and (crstatus='dev'))

Hope this helps!
K
Report this to a Moderator Report this to a Moderator
 28-Sep-2005 02:28
User is offline View Users Profile Print this message


Nick Crossley

Posts: 2
Joined: 30-Sep-2002

SYNERGY/CM 6.3 and 6.4 support a more efficient query for this. You can query using the function 'has_no_associated_task()'. In general, for any relationship X, you can query for 'has_X(some object or query)', 'is_X_of(some object or query)', and 'has_no_X()'.
Report this to a Moderator Report this to a Moderator
 17-Oct-2005 12:37
User is offline View Users Profile Print this message


Manuel Fernando Rivera

Posts: 16
Joined: 26-May-2004

Answer Answer
Hello,

Finally I used the query bellow:

(cvtype='task') and (not is_associated_task_of(cvtype='problem')) and (resolver='%username') and (status!='task_automatic')

Thanks for Kristan and Nick.
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.