Forum Discussion
Hi bmeng,
You can try to use a JSON API call as below:
[ {"command" : "SessionService.authenticate", "args":{"login":"admin","ticket":"ca5c7a6dca425ca5b885cc4c097e653a"}}, {"command" : "UserService.getActionItems"} ]
As a result, it will return all opened reviews for the authenticated user.
Otherwise, you can use the ccollab admin wget command that will return the results of the "Reviews Currently in Progress" report or obtain the needed data from the database:
ccollab admin wget "/go?page=ReportReviewList&formSubmittedreportConfig=1&reviewIdVis=y&reviewTitleVis=y&data-format=html&phaseFilter=inprogress"
OR
SELECT r.review_id AS "REVIEWID" ,r.review_phaseid AS "PHASE" FROM REVIEW r WHERE (r.review_phaseid=1 OR r.review_phaseid=8 OR r.review_phaseid=2 OR r.review_phaseid=3) ORDER BY r.review_id DESC
I hope this helps!
Hi OlegB,
Thanks for your help.
I tried to use with my login username & password:
{"command" : "UserService.getActionItems"}
But it is not what I want. The JSON response only lists all reviews that needs a my attention. In order to get another user's action items, I need know that user's login credentials which is not possible.
I can query all open reviews from the Collaborator's web UI with my login credentials. What I wanted is an equivalent API that lists all open reviews easily using JSON.
Regards,
Bin
Related Content
- 4 years agoZXQA