如何能够把TD和CQ的bug同步了？说下步骤

awei114

我查了很多资料，都是推荐使用TD的一个插件来做到。但是具体步骤不知道谁清楚啊？看td的文档没调通。请教了！
TD和CQ的同步插件是双向的吗？有谁做过吗？交流下

awei114

自己顶起

美元测试

......这个需求很独特啊

awei114

独特吗?哈哈.领导要求,咱们只能做了 .现在我已经在CQ与TD之间通过td提供的同步插件建立link了.但是有error.:Failed to fetch list of values for ClearQuest field '璐ｄ换浜?: 绫诲瀷涓嶅尮閰?,更郁闷的就是其中的field值还是乱码.

希望做过的,知道的留个言.谢谢

bill_hen

如果用Oracle, 可以用 Trigger 在后台做。

----------------------------------------------
For bug tracking, use Bugzero, fully supported
http://www.websina.com/cn/

awei114

Updated defects could not be read: SQLExecDirect: RETCODE=-1, State=37000, Native Error=1033 SQL statement="SELECT id, dbid, version FROM spr d WHERE td_id is null and id in (select distinct T1.id from spr T1,statedef T2,modules T3,severity T4,repeatabel T5,users T6,users T8,project T10 where T1.state = T2.id and T1.modules = T3.dbid and T1.severity = T4.dbid and T1.repeatabel = T5.dbid and T1.submitter = T6.dbid and T1.owner = T8.dbid and T1.project = T10.dbid and (T1.dbid <> 0 and (T10.project = 'D330')) order by T1.id DESC) UNION SELECT id, d.dbid, d.version FROM spr d, history h WHERE h.entity_dbid = d.dbid and h.action_timestamp > '27 Feb 2008 13:23:09' and id in (select distinct T1.id from spr T1,statedef T2,modules T3,severity T4,repeatabel T5,users T6,users T8,project T10 where T1.state = T2.id and T1.modules = T3.dbid and T1.severity = T4.dbid and T1.repeatabel = T5.dbid and T1.submitter = T6.dbid and T1.owner = T8.dbid and T1.project = T10.dbid and (T1.dbid <> 0 and (T10.project = 'D330')) order by T1.id DESC) " [Microsoft][ODBC SQL Server Driver][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
以上是我在做TD与CQ挂接时出现的问题，那位遇到过？请教了。我在另外的帖子看到过有人出现过问题，不知道你们解决了吗？：http://bbs.51testing.com/viewthread.php?tid=2608

awei114

高人指点下阿，如果我在建立link是不指定cq的query，选择none，则可以连接正常，能够把cq中的用户都导入到TD中。但是defect无法导入到TD，TD内的也无法导入到CQ。最主要的还是如果无法选择query则就是便是一个TD项目对应一个CQ的datebase。这就太不现实了。大家都知道CQ的datebase中一般可以包括很多项目的。

awei114

没有知道的吗？ ，