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
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:
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.