Create a CBR query from Enterprise Manager

Use the Content Engine Query Builder in Enterprise Manager to create content-based retrieval (CBR) queries across an object store database and any of its storage areas that are set up for indexing.

To create a CBR query from Enterprise Manager

  1. Right-click the Search Results node of the object store you want to search, and click New Search.
  2. Click View > SQL View.
  3. Enter the SQL command 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')

    This example tells the query builder to find all indexed documents within the selected object store that contain the word "test." You can copy this text into your SQL text window and replace "test" with 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.

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

  4. Click OK to start the search. The query builder displays a list of documents containing the text that meets your search criteria.

CBR queries use a combination of SQL and Verity Query Language syntax. See Create, load, and save a SQL query and SQL Syntax Reference for additional information about building queries.