What is the maximum file size that I can upload to a Collaborator Review?
I'm trying to upload some TFS changesets to a Collaborator Review but get error messages. I suspect it is the file size of a .docx included in the changeset as I can't manually upload it either in the browser. What is the maximum file size I can upload? This one is a .docx that is 409KB
Accessing internalCustomFields for Triggers in Collaborator
Hello world, I can use the http://collaborator.server/services/json/v1 API with the following JSON body to get data about a review. [ { "command" : "ReviewService.findReviewById", "args" : { "reviewId" : "42" } }] Specifically, it includes the following internalCustomFields key: "internalCustomFields" : [ { "name" : "JiraIssueId", "value" : [ "10600" ] }, { "name" : "ExternalTaskId", "value" : [ "" ] } ] I would like to use this JiraIssueId field for a review as an argument to one of the configurable Triggers (say Review Phase Changed for example). Does anyone know how I would access this internal field? I know I can use ${review.custom.foo} for visible custom fields that I create, but the internal custom fields are not documented in the http://collaborator.server/manual/index.html?admin_var_subst.html documentation. I've tried ${review.internal.JiraIssueId}, ${review.internalCustomFields.JiraIssueId}, and ${review.custom.JiraIssueId} but none of them work (giving me the following error) Error: Invalid input: Parameters: ${review.internalCustom.JiraIssueId} is not a valid substitution keyword Thanks for any help! Best, ~ChrisHow can I resolve "content for version #x is not available" when content exists on server?
Hello world, When trying to view a diff, I'm seeing an error message: Content for version #4 is not available - it was probably archived by your administrator. (Content MD5: 0b5cc2fd6db3e718e772f17fa4ed0ce7) As an administrator, I can verify that no one intentionally archived that file. What's more, is that I can still find the contents of the diff at [CacheRootLocation]/0b/5c/0b5cc2fd6db3e718e772f17fa4ed0ce7. Has anyone experienced this issue before? Does anyone know how I could resolve this? I've tried restarting the server; deleting the file and restarting the server; and restoring the file and restarting the server. This is happening for other files in the same review and for all the files in a few other reviews as well. I doubtit's related, but we renewed our license between the time when those reviews were created and now when we're trying to view the diffs. Thanks for any help! Best, ~Chris
Collaborator plugin install error on RTC
I can't install collaborator plugin v9.5.9502 (ccollab_client_9_5_9502_001_update_site.zip) to RTC Eclipse client 5.0.2. I have the following error: Cannot complete the install because one or more required items could not be found. Software being installed: Collaborator 9.5.9502.001 (com.smartbear.collaborator.base.feature.feature.group 9.5.9502.001) Missing requirement: Collaborator - Resources Support 9.5.9502.001 (com.smartbear.collaborator.ide 9.5.9502.001) requires 'package org.osgi.util.tracker [1.5.0,2.0.0)' but it could not be found Cannot satisfy dependency: From: Collaborator 9.5.9502.001 (com.smartbear.collaborator.base.feature.feature.group 9.5.9502.001) To: com.smartbear.collaborator.ide [9.5.9502.001] The RTC Eclipse IDE is the RTC-Client-Win-5.0.2.zip version. I would be pleased if anyone have any clue about it.
collaborator running but no splash page
While the service is able to start and status shows it's running the URL splash page is does not come up and sits at 'waiting for ccollab'. [root@voyager ccollab_server]# ./ccollab-server status ccollab-server is running. [root@voyager ccollab_server]# ./ccollab-server run Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Server version: Apache Tomcat/8.5.24 INFO: JVM Vendor: Oracle Corporation Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.VersionLoggerListener log INFO: CATALINA_BASE: /common/ccollab_server/tomcat Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.VersionLoggerListener log INFO: CATALINA_HOME: /common/ccollab_server/tomcat Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Di4jv=0 Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Di4j.vpt=true Nov 04, 2020 3:44:08 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib] Nov 04, 2020 3:44:08 PM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["http-nio-8080"] Nov 04, 2020 3:44:08 PM org.apache.catalina.core.StandardService initInternal SEVERE: Failed to initialize connector [Connector[HTTP/1.1-8080]] Caused by: org.apache.catalina.LifecycleException: Protocol handler initialization failed at org.apache.catalina.connector.Connector.initInternal(Connector.java:995) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107) ... 17 more Caused by: java.net.BindException: Address already in use at sun.nio.ch.Net.bind0(Native Method) at sun.nio.ch.Net.bind(Net.java:433) at sun.nio.ch.Net.bind(Net.java:425) at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:220) at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:85) at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:210) at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1082) at org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:267) at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:581) at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:66) at org.apache.catalina.connector.Connector.initInternal(Connector.java:993) ... 18 more Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 836 ms Nov 04, 2020 3:44:08 PM org.apache.catalina.core.StandardService startInternal INFO: Starting service [Catalina] Nov 04, 2020 3:44:08 PM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet Engine: Apache Tomcat/8.5.24 Nov 04, 2020 3:44:08 PM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor [/common/ccollab_server/tomcat/conf/Catalina/localhost/ROOT.xml] Nov 04, 2020 3:44:45 PM org.apache.tomcat.jdbc.pool.ConnectionPool init SEVERE: Unable to create initial connections of pool. java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-11-04 21:44:44 heartbeat - read: -4876 ms. Nov 04, 2020 3:44:46 PM org.apache.jasper.servlet.TldScanner scanJars INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. System property [org.owasp.esapi.opsteam] is not set System property [org.owasp.esapi.devteam] is not set Attempting to load ESAPI.properties via file I/O. Attempting to load ESAPI.properties as resource file via file I/O. Not found in 'org.owasp.esapi.resources' directory or file not readable: /common/ccollab_server/tomcat/ESAPI.properties Not found in SystemResource Directory/resourceDirectory: .esapi/ESAPI.properties Not found in 'user.home' (/root) directory: /root/esapi/ESAPI.properties Loading ESAPI.properties via file I/O failed. Exception was: java.io.FileNotFoundException Attempting to load ESAPI.properties via the classpath. SUCCESSFULLY LOADED ESAPI.properties via the CLASSPATH from '/ (root)' using current thread context class loader! SecurityConfiguration for Validator.ConfigurationFile.MultiValued not found in ESAPI.properties. Using default: false SecurityConfiguration for Validator.ConfigurationFile not found in ESAPI.properties. Using default: validation.properties Attempting to load validation.properties via file I/O. Attempting to load validation.properties as resource file via file I/O. Not found in 'org.owasp.esapi.resources' directory or file not readable: /common/ccollab_server/tomcat/validation.properties Not found in SystemResource Directory/resourceDirectory: .esapi/validation.properties Not found in 'user.home' (/root) directory: /root/esapi/validation.properties Loading validation.properties via file I/O failed. Attempting to load validation.properties via the classpath. validation.properties could not be loaded by any means. fail. Exception was: java.lang.IllegalArgumentException: Failed to load ESAPI.properties as a classloader resource. SecurityConfiguration for ESAPI.printProperties not found in ESAPI.properties. Using default: false SecurityConfiguration for Encryptor.CipherTransformation not found in ESAPI.properties. Using default: AES/CBC/PKCS5Padding SecurityConfiguration for Logger.ApplicationName not found in ESAPI.properties. Using default: DefaultName Nov 04, 2020 3:45:02 PM org.apache.tomcat.jdbc.pool.ConnectionPool init SEVERE: Unable to create initial connections of pool. java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-11-04 21:45:01 heartbeat - read: -1327 ms. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482) at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118) at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107) at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:560) at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:244) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) at org.apache.naming.NamingContext.lookup(NamingContext.java:839) at org.apache.naming.NamingContext.lookup(NamingContext.java:159) at org.apache.naming.NamingContext.lookup(NamingContext.java:827) Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-11-04 21:45:01 heartbeat - read: -1327 ms. at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source) at org.hsqldb.persist.Logger.acquireLock(Unknown Source) at org.hsqldb.persist.Logger.open(Unknown Source) at org.hsqldb.Database.reopen(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.DatabaseManager.newSession(Unknown Source) ... 38 more Nov 04, 2020 3:45:02 PM org.apache.naming.NamingContext lookup WARNING: Unexpected exception resolving reference java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-11-04 21:45:01 heartbeat - read: -1327 ms. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482) at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118) at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107) at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:560) at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:244) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) at org.apache.naming.NamingContext.lookup(NamingContext.java:839) at org.apache.naming.NamingContext.lookup(NamingContext.java:159) at org.apache.naming.NamingContext.lookup(NamingContext.java:827) at org.apache.naming.NamingContext.lookup(NamingContext.java:173) at com.smartbear.ccollab.CollabReusable.getDatabaseConnection(CollabReusable.java:521) at com.smartbear.ccollab.CollabReusable$1.createEngine(CollabReusable.java:267) at com.smartbear.ccollab.datamodel.manager.EngineManagerTrivial.acquire(EngineManagerTrivial.java:26) at com.smartbear.ccollab.CollabReusable.getEngine(CollabReusable.java:174) at com.smartbear.ccollab.CodeCollaborator.start(CodeCollaborator.java:201) at com.smartbear.ccollab.CollaboratorInitializationListener.contextInitialized(CollaboratorInitializationListener.java:85) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-11-04 21:45:01 heartbeat - read: -1327 ms. at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source) at org.hsqldb.persist.Logger.acquireLock(Unknown Source) at org.hsqldb.persist.Logger.open(Unknown Source) at org.hsqldb.Database.reopen(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.DatabaseManager.newSession(Unknown Source) ... 38 more Nov 04, 2020 3:45:02 PM org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending context initialized event to listener instance of class [com.smartbear.ccollab.CollaboratorInitializationListener] WARNING: Unexpected exception resolving reference java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5429) at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@263b0255[file =/common/ccollab_server/tomcat/database.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-11-04 21:45:11 heartbeat - read: -1856 ms. at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source) at org.hsqldb.persist.Logger.acquireLock(Unknown Source) at org.hsqldb.persist.Logger.open(Unknown Source) at org.hsqldb.Database.reopen(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.DatabaseManager.newSession(Unknown Source) ... 37 more Nov 04, 2020 3:45:13 PM org.apache.catalina.core.StandardContext listenerStop SEVERE: Exception sending context destroyed event to listener instance of class [com.smartbear.ccollab.CollaboratorInitializationListener] java.lang.NullPointerException: key can't be null at java.lang.System.checkKey(System.java:840) at java.lang.System.getProperty(System.java:752) at com.smartbear.util.SmartBearUtils.incrementSystemPropertyCounter(SmartBearUtils.java:615) at com.smartbear.ccollab.CollaboratorInitializationListener.contextDestroyed(CollaboratorInitializationListener.java:230) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5429) at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Nov 04, 2020 3:45:13 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc WARNING: The web application [ROOT] registered the JDBC driver [org.hsqldb.jdbc.JDBCDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. Nov 04, 2020 3:45:13 PM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deployment of configuration descriptor [/common/ccollab_server/tomcat/conf/Catalina/localhost/ROOT.xml] has finished in [64,182] ms Nov 04, 2020 3:45:13 PM org.apache.catalina.startup.Catalina start INFO: Server startup in 64264 ms: Can anyone help please? Outside of the start/stop/force-reload/status commands Im not sure what to do here. Thanks.
Is there an option to view the differences between the two versions of the file side by side?
Is there a way to view the differences side by side instead of synchronous scrolling while reviewing the changes madeto the file. I looked throughhttps://community.smartbear.com/t5/Collaborator/Using-Beyond-Compare-as-the-external-diff-tool-for-CC-v9-web/td-p/156998 but that also doesn't solve my concern.
Now Live: 7th Annual State of Code Review Survey
We're thrilled to launch our 7th Annual State of Code Review Survey! For 7 years, our State of Code Reviewshave highlighted the most prevalent trends relative to prior years, approaches to code review, and the top best practices shared by you and your peers. And now we need your help for this year's report! Take the survey!Share your perspective on code and document review in 2020. $100 Amazon Gift Card Giveaway You'll be entered to win a $100 Amazon Gift Card for participating, AND you'll be one of the first to receive a copy of our 2020 report. Thank you for everyone's participation.Collaborator 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:
