Is there a way to get a list of all ongoing reviews using the command line client ccollab?

Question

Hello community,&nbsp;I want to integrate our corporate tools with code collaborator. I need a way to get a list of all ongoing reviews using the command line client. How ever I can't find a command working for me. And when I try the wget I get the login page printed on the console.We use the version&nbsp;ccollab v9.4.9400&nbsp;Greetings,Simon

alexeykryuchkov · Answer

Hi,
&nbsp;
I don't see a direct way to do this. A possible (but&nbsp;not very elegant) solution will be creating two batch files. The first one should execute the&nbsp;admin review edit ask command and redirect its output to a file (or probably a variable):&nbsp;&nbsp;
ccollab admin review edit ask &gt; reviews.txt
In the middle of the output, there will be a list of ongoing reviews, so it will be possible to parse it and collect&nbsp;the IDs. However, it is not sufficient to just run this batch file as such a command will require user input. To work around this, run the second batch file instead:
start getreviews.bat
timeout /t 10
taskkill /F /IM ccollab.exe
It runs the first batch file and terminates the ccollab client after&nbsp;the output is saved.
&nbsp;
&nbsp;

conti · Answer

Hello&nbsp;Alexey,&nbsp;Thank you very much!It seems I get a very short list using the ask command:&nbsp;Reviews you can upload to:Review #310: "TestCMD"Review #537: "nochntest"Review #646: "cmdlinereview"Review #670: "213072:1: Review Another Test by scripting"Review #671: "213072:1: Review Another Test by scripting"Review #672: "Untitled Review"Review #265: "Untitled Review"Review #267: "Untitled Review"Review #219: "EEE Code Review"Review #674: "418211:1: Review Another Test by scripting"Review #222: "test"Review #865: "59787:24: Review 59787:24: Auto-created Review for CR 59787"Review #866: "59787:24: Review 59787:24: Auto-created Review for CR 59787"Review #869: "59787:24: Review Auto-created Review for CR 59787"Review #942: "Auto-created review for CR 436866"&nbsp;&gt;&nbsp;But when I open the Web GUI I get a much longer list with around 80-90 reviews which are all open.Is there a way to get all open&nbsp;reviews?&nbsp;Best regards,Simon

alexeykryuchkov · Answer

Hi,
&nbsp;
Probably, you need to concentrate on the&nbsp;wget&nbsp;approach. The fact that you get the login page in console should mean that the command line client is not authorized to view what you request. So, check the following:

Make sure that ccollab is logged in to the server as a user who can view the report.
Make sure that the relative URL is correct. Probably, it will be better to query a report in the CSV format. To get a relative link for such a report, generate a report from web UI find the link that exports to CSV.
Check if the login page will be in the output is if you execute a simple command like

ccollab admin wget ui

Forum Discussion

Is there a way to get a list of all ongoing reviews using the command line client ccollab?

Recent Discussions

Getting list of all users via cli cmd

How to migrate Code Collaborator database from MySQL 5.6 on RedHat to MySQL 8.0 on Ubuntu?

Dismiss Review / Commit Files - message

Related Content

ccollab admin review set-participants doesn't work if user id is in digits

review auto notifications

Bulk delete of Reviews