Provide a way to filter by Review Custom Fields in Defect reports
I have a Reveiw Custom Field named Project. I would like a Customizable Defect Report where I can filter using the Project field. I do not want to use Groups to achieve this (as was suggested by a sales representative).5KViews2likes1CommentMy team needs the ability to add a custom template field to a defect report
My team needs the ability to add a custom template field to a defect report. The options that's been suggested to me by SmartBear support was that a custom SQL report would meet this need. Adding the option to do this within Collaborator would be a big improvement. In my case, I only need 1 custom field from the template to be able to filter the defect list as needed.1.6KViews0likes0Commentsinclude assignee from defects in action report or at least on reports
We utilize the assignee field on defects to drive action items. However, we have not been able to find a way that this is communicated in any method outside of the actual review. Having this on the home page and/or notification activity (tray, in app, email) would help to expedite action.1.3KViews0likes4CommentsSome reviews stopped on the loading screen.
Hello Some reviews stopped on the loading screen. 2021-12-20 08:32:09,991 INFO http-nio-8080-exec-9 com.smartbear.ccollab.rpc.RpcGwtServlet$GwtInvocationHandler - Error invoking java.lang.NullPointerException: Name is null at java.lang.Enum.valueOf(Enum.java:236) at com.smartbear.ccollab.datamodel.RemoteSystemReviewRelation$Type.valueOf(RemoteSystemReviewRelation.java:19) at com.smartbear.ccollab.datamodel.RemoteSystemReviewRelation.getRelationType(RemoteSystemReviewRelation.java:153) at com.smartbear.ccollab.datamodel.RemoteSystemReviewRelation.isPullRequest(RemoteSystemReviewRelation.java:136) at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:174) at java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1359) at java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:126) at java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:498) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:485) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) at java.util.stream.FindOps$FindOp.evaluateSequential(FindOps.java:152) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.util.stream.ReferencePipeline.findFirst(ReferencePipeline.java:464) at com.smartbear.ccollab.datamodel.Review.getPullRequestRelation(Review.java:5134) at com.smartbear.ccollab.datamodel.Review.isCreatedByPR(Review.java:5125) at com.smartbear.ccollab.datamodel.Review.getChangelists(Review.java:3028) at com.smartbear.ccollab.datamodel.Review.getChangelists(Review.java:3042) at com.smartbear.ccollab.datamodel.Review.getChangelists(Review.java:3046) at com.smartbear.ccollab.datamodel.client.unversioned.impl.UnversionedReviewSummaryServerDMFactory.getHidedFilesCount(UnversionedReviewSummaryServerDMFactory.java:757) at com.smartbear.ccollab.datamodel.client.unversioned.impl.UnversionedReviewSummaryServerDMFactory.<init>(UnversionedReviewSummaryServerDMFactory.java:138) at com.smartbear.ccollab.service.impl.unversioned.UnversionedClientApiImpl.getReviewSummaryEverythingButFiles(UnversionedClientApiImpl.java:648) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.smartbear.ccollab.rpc.RpcGwtServlet$GwtInvocationHandler.invoke(RpcGwtServlet.java:437) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.sun.proxy.$Proxy71.getReviewSummaryEverythingButFiles(Unknown Source) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.smartbear.ccollab.service.impl.ServerNotInitializedExceptionProxy.invoke(ServerNotInitializedExceptionProxy.java:45) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.smartbear.ccollab.rpc.RpcGwtServlet$LoggingInvocationHandler.invoke(RpcGwtServlet.java:1178) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.smartbear.ccollab.rpc.RpcGwtServlet$TimingInvocationHandler.invoke(RpcGwtServlet.java:1237) at com.smartbear.util.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:28) at com.sun.proxy.$Proxy71.getReviewSummaryEverythingButFiles(Unknown Source) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.smartbear.ccollab.service.impl.ExposeExceptionsProxy.invoke(ExposeExceptionsProxy.java:29) at com.sun.proxy.$Proxy71.getReviewSummaryEverythingButFiles(Unknown Source) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) Does anyone know what the problem is?1.2KViews0likes1CommentLog all activities of users and admins in Collaborator
In a Large enterprise there will be multiple admins. To track who has done what, Admin should be able to get the log of all users activities. Like, Disabling and Enabling review templates, Disabling and enabling users or adding users etc. In simple terms a log should be generated for every activity happens in Collaborator through all the ways. ex: GUI, API, Collab client, Thirdpart clients, Commands etc.979Views1like0CommentsDetailed report extracting review note and associated code line(s)
We are investigating to which extent it would be possible to automate reviews partly by using AI. To that end we need an ability to extract (across a collection of reviews) review comments and the associated code line(s). The output could for example be in an Excel file. We have not been able to find this ability in the standard reporting tool, but we believe that this feature would also be usable in other use cases where you would like to analyse your reviews and find patterns.890Views2likes0CommentsCollaborator Database Queries
Collaborator has a robust, built-in Report tool, offering many selections and filtering options to gather the information that is important to your review process. However, there are times when the one option you are looking for isn't one of the available selections or filters. Here's where Collaborator's associated SQL database comes in for generating custom reports. Specific information on the database schema and table relationships are foundhere in the online documentation. Additionally, SmartBear's Support pages for Collaborator offers many useful links to videos and other artifacts to help with your Collaborator deployment. I recently had a customer request for some assistance on verifying if specific commits had been associated with reviews. Collaborator has a report generation option for this specific request, but the request was based on some scripting they were doing to enhance their CI/CD process. I put together a quick general query that they can use as a basis for refining exactly what they need for their script. The SQL query below is used to look at your review IDs, and output a table showing the title, phase, and associated commits with those reviews. To get this report, I used the schema diagram to find my associated SQL tables and how they linked together, then used a few nested JOIN statements for the formatting I needed. Collaborator also provides SQL output scripts used to generate many of the reports in the Reports tab. These can be used as great starting points to develop the queries you need for your reports and data parsing, and how I got started on the development of the script for this request. In short, take advantage of the information in the database to enhance your reporting and automated workflows. Sample SQL query: SELECT review.review_id AS `Review ID` ,review.review_title AS `Review Title` ,phase.phase_title AS `Phase` ,version.version_scmversionname AS `Commit ID` FROM review INNER JOIN joinreviewchangelist ON review.review_id = joinreviewchangelist.joinreviewchangelist_reviewid INNER JOIN changelist ON joinreviewchangelist.joinreviewchangelist_changelistid = changelist.changelist_id INNER JOIN version ON changelist.changelist_id = version.version_changelistid INNER JOIN phase ON review.review_phaseid = phase.phase_id ORDER BY review.review_id DESC Sample output in MySQL Workbench:837Views0likes0CommentsGet list of git commits for a review?
We need to confirm that every commit in our git master branch has been reviewed in some completed CC review. Most people use the "Add Git Diffs..." and then do a master-their_branch diff. After their review is approved and they've merged their branch into master, we'd like to generate a report that shows that every single commit in the master branch has been reviewed. Any techniques, help or insight on how to start off or to do this will be greatly appreciated. For example: if there is a Rest API that I can call for each review that lists all of the commit SHAs, then I can write a quick script to call that and then use "git log" against master and thereby confirm that no commit has been left out. TIA!819Views0likes0Commentsget export of report programatically
I'm part of a team that collects metrics for our company and we've been asked to integrate with Collaborator. When I run the All Defects report from the web, this is the URL that's displayed: https://collab.mycompany.com//go?groupFilter=9&defectReviewIdVis=y&reviewCompletionDateVis=y&reportTitle=All+Defects&defectCreatedOnVis=y&groupDepth=all&defectIdVis=y&defectStateVis=y&data-format=report_html&component=ErrorsAndMessages&formSubmittedreportConfig=1&sort0=order%3Ddesc%7C%7C%7Ccol%3DdefectId&sort1=col%3D%7C%7C%7Corder%3Dasc&page=ReportDefectList&ErrorsAndMessages_fingerPrint=861101#data" We've been having a lot of trouble figuring out how to get this report through the json api. Is this possible? Is there another way to do it? Thanks769Views0likes1Comment