Run CBR query from Enterprise Manager

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

  1. Launch Content Engine Query Builder.
  2. Select SQL as the Query View Selection.
  3. Enter your SQL command set using a syntax similar to the following example:

    SELECT d.This FROM Document d INNER JOIN ContentSearch c ON d.This = c.QueriedObject WHERE CONTAINS(d.*,'test')

    or

    SELECT d.This FROM Document d INNER JOIN ContentSearch c ON d.This = c.QueriedObject WHERE FREETEXT(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.

    NOTE  The FREETEXT operator differs from the CONTAINS operator in the following ways:

  4. Click OK to start the search. The query builder displays a document list with the text that meets your search criteria.

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.