Use Enterprise Manager's Content Engine Query Builder to run CBR queries across an object store's database and any of its storage areas set up for indexing.
To run the CBR query from Enterprise Manager
SELECT d.This FROM Document d INNER JOIN ContentSearch
c ON d.This = c.QueriedObject WHERE CONTAINS(d.*,'test')
NOTE This
example tells the query builder to find all indexed documents within
the selected object store that contain the word "test."
If you prefer, copy this text into your SQL text window. Instead of "test," substitute the word or phrase you want to find.
You can also use boolean operator symbols (such as +) without
spaces between words to narrow your search. Do not use words
included on an exclusion word list.
or
SELECT d.This FROM Document d INNER JOIN ContentSearch c ON d.This = c.QueriedObject WHERE FREETEXT(d.*,'test')
NOTE The FREETEXT operator differs from the CONTAINS operator in the following ways:
After creating the SQL commands, save them in a file to re-use for another SQL search, as described in Create, load, and save a SQL query.