Fyodor_A
AlumniJoined 7 years ago
User Profile
Alumni
User Widgets
Contributions
Make Collaborator client support context path.
Submitting on behalf of Clue Technologies SL: We have configured the Collaborator instance to use a non-root context path, so we can route the connections under our own subdomain. The steps we followed are detailed below: - The file <Collaborator Installation dir>/tomcat/conf/Catalina/localhost/ROOT.xml has been renamed to context.xml.default - The webapp directory <Collaborator Installation dir>/tomcat/webapps/ROOT has been renamed to our context path name (in our case "reviews") As a result, the WebUI is accessible at the.server.net/reviews Currently, the Collaborator client doesn't support the context path. It ignores everything you type after "subdomain.example.com/" and tries to find the API at 'subdomain.example.com/services/json/v1' instead of 'subdomain.example.com/reviews/services/json/v1' The request is to make the Collaborator client support connecting to a non-root context path508Views0likes0CommentsRe: Action Items not loading in Web GUI Home Page, Desktop GUI
Hi, Probably, you have faced a known issue - COLLAB-5920. The fix is planned for one of the future releases of Collaborator 12. To work this around, please try the following approach: Look for non-closed reviews in which the user is a participant (Reviews in Progress report) As the user, view each review and mark any unread comments as 'read' (click on "Mark all read" for each conversation)1.2KViews0likes0CommentsRe: Migrating Code Collaborator To SAML Authenticaiton
Hi, The main identification of a user in Collaborator is a login. If the user has identical Collaborator and SSO logins, this user shall be able to access the account after the migration. If the logins differ, you will need to change the user's login in Collaborator using the following command: ccollab admin user edit --new-login <new-username(which is used in SSO)> <existing-username>2.5KViews0likes3CommentsRe: Need a sample SQL query for the "ALL Defects" report.
Hi, Here is the 'All Defects' report SQL query: SELECT d.defect_id AS `defectid` ,dReview.review_id AS `defectreviewid` ,d.defect_state AS `defectstate` ,d.defect_createdon AS `defectcreatedon` ,dCreat.user_name AS `defectcreatorusername` ,version.version_filepath AS `defectfile` ,d.defect_text AS `defecttext` FROM defect d LEFT OUTER JOIN user dCreat ON (d.defect_userid = dCreat.user_id) LEFT OUTER JOIN review dReview ON (dReview.review_id = d.defect_reviewid) LEFT OUTER JOIN version version ON (version.version_id = d.defect_versionid) ORDER BY d.defect_id DESC Since the database schema hasn't been drastically changed since version 9.3, this query should also work fine with this version.862Views0likes0CommentsRe: findReviews method referenced in JSON API
The 'findReviews' method has two arguments: 'findPlace' and 'searchText'. 'findPlace' accepts the following values: 0 for searching Everywhere 1 for searching in Reviews Titles 2 for searching in User Comments 3 for searching in Custom Fields Please refer to the following example of the JSON query: {"command":"ReviewService.findReviews","args":{"findPlace":1,"searchText":"someword"}} This will return the list of reviews the titles of which contains "someword". I recommend that you use the command-line client command instead of the JSON API query. ccollab admin find review This command returns the list of reviews found by the specified criteria. As for searching by the "Completed On" value, I don't see a way to this using neither the command-line client nor the JSON API request. However, you can do it with the configured 'Recently Completed Reviews' report. Custom reports are also can be gathered by an SQL query. For example, the following query will return the list of the reviews completed in a period from 2019-08-07 to 2019-10-15: SELECT r.review_id AS `reviewid` FROM review r LEFT OUTER JOIN ( SELECT a.activity_reviewid,MIN(a.activity_startsecs) startsecs,MAX(a.activity_startsecs + a.activity_durationsecs) endsecs,SUM(a.activity_durationsecs) totalsecs,SUM(IF((a.activity_code)=('R'),a.activity_durationsecs,0)) reviewersecs,SUM(IF((a.activity_code)=('A'),a.activity_durationsecs,0)) authorsecs FROM activity a GROUP BY a.activity_reviewid) act_summary ON (act_summary.activity_reviewid = r.review_id) LEFT OUTER JOIN ( SELECT d.defect_reviewid,COUNT(defect_id) numDefects,SUM(IF((d.defect_state)=('O'),1,0)) numOpenDefects FROM defect d GROUP BY d.defect_reviewid) defect_summary ON (defect_summary.defect_reviewid = r.review_id) LEFT OUTER JOIN (SELECT a.assignment_reviewid revid, IF((COUNT(u.user_id)= 1),MIN(u.user_name),'(multiple)') user_name, IF((COUNT(u.user_id)= 1),MIN(u.user_login),'(multiple)') user_login FROM assignment a INNER JOIN user u ON (a.assignment_userid=u.user_id) WHERE 2=a.assignment_roleid % 4 GROUP BY a.assignment_reviewid) rAuthor ON (rAuthor.revid = r.review_id) WHERE (IF((r.review_phaseid)=(5),r.review_lastphasechangedateinsecs,NULL)>=1565125200 AND IF((r.review_phaseid)=(5),r.review_lastphasechangedateinsecs,NULL)<=1571086800) AND (r.review_phaseid=5) ORDER BY r.review_id DESC1.8KViews0likes0CommentsShow deleted Clearcase files in the review materials as the deleted revisions.
Submitting the RFE on behalf of Johann Glaser from Infineon Technologies AG-verification: We are facing trouble adding ClearCase files to Collaborator. The specific file has been deleted, and we want to add it so that the reviewers see that it is gone.656Views1like0CommentsExport documents with pins from the diffviewer to the review detailed report in the PDF format.
Posting an idea on behalf of EUCHNER GmbH + Co. KG: Which would be very helpful for us if we could download the pins that are superimposed in the PDF as a file. Because in the report the positions are delivered but not transferable into the document without seeing the pins in the document. Since we also have a graphical part in the reviewed document, it's already necessary from our point of view to at least determine where these pins are to be assigned.815Views4likes0CommentsAllow reviewers to change the "Waiting" state when the review is in the Rework phase
Submitting the RFE on behalf of James Wagner from L-3 Technologies, CSG: Allow reviewers to change what they are waiting for, when the review is in the Rework phase. For example, a reviewer wants to become Active only when the File Activity occurs instead of Any activity.3.6KViews4likes6CommentsSwitch for a restriction finishing a review without comments
Alvin Lau from Agilent Technologies LDA Malaysia Sdn Bh has requested the following feature: An option that would make it impossible to finish a review if there are no comments in it. Possibly it should an option that would switch the requirement to create at least one or the specific number of comment in order to be able to finish the review.990Views0likes1Comment