IBM FileNet P8, Version 5.2.1            

Creating database indexes for class properties (case-insensitive search)

The procedure for creating database indexes differs, based on whether case-insensitive search behavior is in effect. You can use the administration console to create supporting indexes in most circumstances.

Content Platform Engine implements case-insensitive search behavior by including the LOWER function on the property and on the string value in query statements, so that the search condition becomes LOWER(property)=LOWER('Value'). However, for the following databases, the administration console cannot create supporting indexes in this way because the LOWER function is not supported on a column in an index.
Tip: Case-insensitive search behavior means that queries ignore character case when searching for string values. For information about setting this behavior, see Setting case-insensitive search behavior for object store searches.


Last updated: October 2015
p8pcc201.htm

© Copyright IBM Corporation 2015.