Forum Discussion

nguyena2's avatar
nguyena2
Occasional Contributor
6 years ago

Query All Reviews in Progress

Hello,   Is there a way to query all reviews in progress that has been idle for over a year?  I want to have a query that would run to create a list of idle reviews so that I can notify users to cl...
AlexeyKryuchkov's avatar
AlexeyKryuchkov
Staff
6 years ago

Hi,

 

It looks like you just need to choose the Stalled Reviews report, specify Idle For greater than 31536000 (the number of seconds in a year) and Run it.

  • nguyena2's avatar
    nguyena2
    Occasional Contributor
    6 years ago

    Awesome!  Is there a script/API I can use to automatically run and export the file externally?

    • AlexeyKryuchkov's avatar
      AlexeyKryuchkov
      Staff
      6 years ago

      Hi,

       

      Collaborator Web UI supports export to CSV, XLS, and other formats. It generates parameterized URLs that can be used in automation. For details, refer to the "Exporting Reports" section of the mentioned topic:

      https://support.smartbear.com/viewarticle/91500/