Use advanced search to find reviews by comments

When a review moves to a state of Resolving, an admin or review coordinator can mark the entire review as Completed and optionally approve components. Regardless of whether components are approved, the user resolving the review can enter a comment on the Review Approval screen. You can search these approval comments to find a review.

For example, if you want to find all reviews with an approval comment of "Fix image resolution" you can search for this phrase if it's entered on the Review Approval screen.

You can see these comments on the Reviews Management tab in the Comments column. This column is hidden by default.

You cannot search for comments or discussion within a review.

For instructions on creating other review queries:

To use advanced search to find reviews by approval comments:

  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 Comments column:
    1. Next to any column name, select the drop down arrow.
    2. Select Columns.

    3. Select the checkbox for Comment.
      • You see the column in the list of reviews.
      • You see it as the last 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 manually add search parameters:
    1. In the Field list, select Comment.
    2. In the Operator list, select the symbol that specifies how you want to search. For example, if you select , you want .
      • To find reviews that match your value exactly, select = the equal sign.
      • To find reviews that don't contain a keyword in the comments, select <> the not equal sign.
      • To find reviews that have part or all of a keyword in the comments, select Contains.
      • To find reviews that don't have part or all of a keyword in the comments, select Does Not Contain.
      • To find reviews that have a comment that starts with part or all of a keyword, select Starts With.
      • To find reviews that have a comment that does not start with part or all of a keyword, select Does Not Start With.
      • To find reviews that have a comment that ends with part or all of a keyword, select Ends With.
      • To find reviews that have a comment that does not end with part or all of a keyword, select Does Not End With.
    3. In the Value field, enter the text you're searching for or excluding.
    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 comments in the review:
    1. In the review's row, right-click and select Create report.
    2. For more help, follow the steps in Create a report for a review.
  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.