IBM FileNet P8, Version 5.2.1            

CBR query syntax introduction

A CBR query includes a CONTAINS function call to perform a full-text search.

The following example shows the main syntactical elements of a CBR query:
SELECT d.This
FROM Document d 
INNER JOIN ContentSearch c ON d.This = c.QueriedObject
WHERE CONTAINS(d.*,'lion AND tiger')
ORDER BY c.Rank
OPTIONS (FULLTEXTROWLIMIT 500)

Using partition properties in a query to optimize query performance

To optimize query performance, use a partition property in the WHERE clause of the SQL statement. The search terms that reference the partition property must be separated by AND conjunctions at the highest level of the query. For example, suppose that DateReceived is a partition property. The following query shows how a DateReceived custom property might be referenced to optimize search performance:
SELECT d.This
FROM Document d
INNER JOIN ContentSearch c ON d.This = c.QueriedObject
WHERE CONTAINS(d.*,'lion AND tiger')
AND d.DateReceived >= 2008-10-26
AND d.DateReceived < 2009-03-25
ORDER BY c.Rank
OPTIONS (FULLTEXTROWLIMIT 500)

Using a partition property in this way in the query has the following effect: the full-text search is narrowed to the indexes with partition property values that overlap the query-specified range of property values. In this example, the query-specified range of values for DateReceived is from 2008-10-26 to 2009-03-25. Consequently, the lion AND tiger search is narrowed to those indexes with an overlapping range of DateReceived values for the objects indexed.



Last updated: October 2015
csscbr_cbrquery_introduction.htm

© Copyright IBM Corporation 2015.