Use advanced search to find reviews by approval

When a review is in a state of Resolving, after all reviewers have marked their reviews as Completed, review coordinators and administrators have the option to approve components in the review. If you want to find a review by the criteria that when the review was resolved components were approved or not approved, you can use the advanced search query builder.

For help creating other review queries:

To use advanced search to find approved review components:

  1. Click Reviews.
  2. On the Reviews Management tab, click the advanced search icon .
  3. If you want to include reviews in your results that have any of the following States, select the corresponding checkbox:
    • Include Completed
    • Include Cancelled
    • Include Archived
  4. To display the Approved column:
    1. Next to any column name, select the drop down arrow.
    2. Select Columns.

    3. Select the checkbox for Approved.
      • You see the column in the list of reviews.
      • If all columns are displayed, you see it after the Interactive column.
  5. Optionally, to use a saved query to fill in search parameters:
    1. In Saved Queries, select an option.
    2. You can manually change search parameters if necessary.
    3. If you make changes to a saved query, you can save the query with a new name by clicking Save query . For more help, read Update a saved review query.
  6. To find reviews where components were approved upon resolving:
    1. In the Field list, select Approved.
    2. To find reviews where components were approved when resolving:
      1. In the Operator list, select = the equal sign.
      2. In the Value field, select Yes.

        Optionally, you can select an Operator of <> not equal to, and a Value of No.

    3. To find reviews where components were not approved when resolving:
      1. In the Operator list, select the = the not equal sign.
      2. In the Value field, select No.

        Optionally, you can select an Operator of <> not equal to, and a Value of Yes.

    4. Optionally:
      • To add additional search parameters, click Add add_clause.
      • If you have multiple parameters in the query, choose the appropriate criteria from the And/Or list.
      • To group rows together, select the checkbox for each row, and then click the group icon .
      • You can save your search parameters as a saved query by click Save query as . For more help, read Save a new review query.
  7. To run your search, click the search icon .
    Your search results are shown in a list on the Reviews pane. The search results also change the information you see on the Reviewers and Review Components panels. These panels now only display users and components included in the search results.
    If you encounter an error with a search that uses multiple rows, try removing all but the first row and run the search again. Review your search results and make sure that your other search criteria are valid before adding them back into the query.
  8. To see the list of components in the review that were approved:
    1. In the review's row, right-click and select Open details...
    2. On the View Review screen, look in the Components section.

      Approved components are shown with a green system lock in the second column before the State column.

  9. Optionally, to save the list of reviews that match the search as a CSV file and includes all individual reviewer’s statuses, click Save as CSV ExportCSV.