![]() |
Telelogic SYNERGY (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() 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. | |
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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()'.
|
|
![]() |
|
![]() |
|
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. |
|
![]() |
Telelogic SYNERGY
» SYNERGY/CM
»
Query for task wiht no CR associated
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.