francois_roux
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Full audit history of a given review
One thing that would be good to have in reporting is the ability to get the full audit history of a given review. Currently the review report only gives you the current status and history of defects and attachments I believe. For instance, recently we had a case where a review was created, then cancelled and re-opened multiple times, before being cancelled again. The built-in report only shows the last status of cancelled, but also doesn't say who cancelled it. Having looked at the review event table, the actions could not be linked to the user at all. The only other way to do this is currently to check the notifications table, if that is not being archived/cleaned up. That or set up a custom notification to populate a table. But this would be good to have built-in.8.2KViews6likes3CommentsFull activity history of a review
Is there a way in the database to get the full list of activities for a review, including who actioned it? I was looking to find out who cancelled a review (was cancelled/uncancelled then cancelled again). The only way was to check the notifications that went out. The ReviewEevent table just contains an id, reviewid,essentially previous phase, new phase, a time field? and entitytypeid. can't seem to match this up with a userid? looks like the reports only show the current state, not the history for all those in between... thanks2.8KViews1like2CommentsRe: Checklist improvement - 2
This would be helpful for us as well. Last year when I asked Smartbear about this though, they mentioned that they've had the request quite a few times before, but at that time, management decided to keep to having only the two states on the checklist, no comments. In the case above an aditional state of -1 could help, but looking at the database (reviewchecklistitem) the state is char(1), so adding other states should be possible - though not sure about the gui client code. As for the commenting part itself - I was advised to just add the comments to the general section, which probably won't be ideal as you may sometimes have a lot of noise and discussions going through there. Not sure about the underlying complexity in the GUI code, but they should be able to add comments *against* the checklist items at least. The events seem to be stored in reviewchecklistevent, so really only need a text field in there to be populated. You won't always want to change the state of the button when you add a comment, so they should really be independent from each other.3KViews0likes0CommentsDefault Template to use on new reviews
Not sure if this already exists somewheer in the depths of the beast, but it would be nice to be able to set the review template to use for a new review based on the user group or name or some other user/admin configurable setting? even a default template for all new reviews. Currently when you create a new review the default template used is often one which the users have no use for, and need to change, often after they have filled in a lot of details, so changing the template to use then resets the form. This is not a problem for the reviews created by script as the template is clearly defined. But where the review is created from the GUI client or web interface, it uses a totally different review template by default, not even the old "Default".1.7KViews3likes0CommentsRe: [CodeReviewer] Download original files in CodeCollaborator
makes sense. Not sure if that functionality is there. However, you should be able to develop an app to get them yourself. The files are saved with the GUID as name, so you just need to figure out which revision uses which GUIDs. Should be straightforward looking at the DB schema and I've done some other scripts which archived the files for certain reviews (which effectively moved all files for the review). Then your app can copy the selected files and rename them to what they need to be. Might take a day or two to develop the app, but it certainly should be possible. Still, it would be a good feature to add (if it's not already there)5KViews0likes1CommentRe: [CodeReviewer] Download original files in CodeCollaborator
What version of Collaborator are you using? There should be a download icon (folder) next to the [After] and the [Before] combo boxes, and on the reviews I tested it downloads the correct version of the file. This goes for binary source files, pdf, xlsx etc as well. Running on 9.2.92005.1KViews0likes3CommentsRe: Removal of uploaded material of completed reviews
Last year sometime I created a SQL script which would do just this, essentially go through reviews meeting a certain criteria (date/age/status etc) and move any physical files to a networked backup location. Removed this when I rebuilt the server with more storage and migrated to 64bit. I'll try to dig out the scripts I used, nothing too complicated, but did the trick pretty well. chances are however that this feature will be reinstated, especially, as you said, the review material is getting more and larger. I do think though, that certain types of review you may not want to keep the files hanging around as it would not make sense, so perhaps just archive certain types of files.14KViews0likes0CommentsRe: Integrate Collborator into Windows shell
you should be able to do that pretty easily using scripting. something like ccollab admin review create --creator timmy --title "test cmdline creation" --custom-field "Overview=testoverview" --custom-field "defect=123456" --deadline '2015-12-12' --display-changelists-as "district" --group "a5afe6af13d2b5224f36b80cda29ba7f" --template "Custom Template" --restrict-access "anyone" ccollab addchanges last . This should generate a new review with specified info, then add all the changed files in the current folder and subfolders to the last review (if your new review was the last one to be generated), otherwise just look up the options for addchanges. guess the tricky bits are the defined data (if you want to pre-fill them) otherwise you can leave them to be filled in once the review has been generated. you can add the above text in a bat file and either set it in your send to folder, or set up the registry to run it off a new rightclick menu option. In any case, it's a pretty simple change which would be welcomed oficially, but for the moment a workaround exists.6.8KViews0likes0CommentsAdditional columns on the main Collaborator web user homepage
Hi, just wondered if it's possible to have additional columns to the main user web page for Collaborator. At the moment there are Review, Progress, Author, My Role, and Deadline. Some users are in a fair number of groups, for instance, and would like the ability to sort their main views accordingly. And if there is a way, will it have to be system wide, or can it be user specific? thanks francois1.3KViews1like0CommentsRe: [CodeReviewer] Re-organising the SCM configurations on the Collaborator client GUUI
Hi Sherif, Eventually got round to this again. Changing the first line on this doesn't seem to make much of a difference, at least not on my system. What I have found is that they are being added to the GUI in the order of the filenames in the profiles folder. so based on the <xxxx>.options values. I have tested on my system and renamed a couple of these - they still seem to work fine, and also now come up in the sequence I need. I guess they are just randomly generated names, not really meaning anything or linked to anything, so safe to rename? thanks1.1KViews0likes0Comments