Hello, I have discovered scmbug just recently, it's a very nice project. I am starting to prototype it for a setup with Subversion as front-end and TestDirector/QC as back-end.
I have some questions (please apologize if the answers are obvious - I'm an scmbug newbie :-) ): - Looking at daemon.conf and TestDirector back-end code, it looks that only one QC Project can be managed by the integration daemon. Is that correct? - Without speaking of Test Director back-end, what is the recommended way of integrating many SCM repositories with many defect tracking repositories? Multiple daemons? - VDD for QC: Rob (nice to meet you :) ) investigated this and I found a thread about it: http://lists.mkgnu.net/pipermail/scmbug-users/2007-July/001185.html, indicating that we are in a dead end. It is actually possible to query all defects that have been modified between two dates, using the OTA API "Command" object (the user account will have to have QC TDAdmin credentials in some cases). It might be possible to do it directly from OTA BugFactory + filters - but I think "Command" will be faster. The query will have to look at the QC AUDIT_LOG table, to find out which defects were modified between two dates ("History" check box must be checked for the fields that need to be monitored). Unfortunately, this is not so simple, as the query depends on the Database Back-end used by QC (which can be queried as part of the tdconnection COM object). An example for Oracle back-end to query all defects modified between 2008-08-01, 1am and 2008-08-20, 11pm: SELECT * FROM AUDIT_LOG, AUDIT_PROPERTIES WHERE AU_ENTITY_TYPE = 'BUG' AND AU_TIME > TO_DATE('2008-08-01 01:00:00', 'YYYY-MM-DD HH24:MI:SS') AND AU_TIME < TO_DATE('2008-08-20 23:00:00', 'YYYY-MM-DD HH24:MI:SS') AND AU_ACTION_ID = AP_ACTION_ID Best regards, Olivier. _______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
