I see there are many ways to search the review database for locating reviews based on title fields, etc. What I am looking for is a way to search for reviews based on comment/bug text. We may have ...
There is a Filter field for this for Review Defects. In your Reports screen, select "Customizable Defect Reports > All Review Defects". Choose the options you require in the top "Columns" frame. In the Filters section you'll see the field "Comment:" [Contains] [ ]. You can insert any string you want to search on in your review database to generate a report filtering specifically on Review Defect comments. Here's an example screen shot of my search looking for defects with the word "Separate" in them:
Results:
You can then export this report in various formats for additional data parsing. If you want to query the database directly, there is also a link to save the SQL query Collaborator used to generate this report that you can then tailor to your particular needs.