Blueriq versions 13.2, 12.13.16, 11.11.27 and higher offer you case-insensitive search out of the box. This applies to searching and filtering data in lists (Aggregate List, Case List, Task List, Work List and Instance List). This article describes how you can configure case insensitive search if you use Oracle combined with an older Blueriq version. |
In OracleText, the full-text index is case insensitive by default. The case-sensitivity of the index can be specified at creation time or changed later using lexer preferences.
By default, Blueriq uses the |
To enable case-sensitivity, a custom lexer must be defined and configured:
begin ctx_ddl.create_preference('example_lexer', 'BASIC_LEXER'); ctx_ddl.set_attribute('example_lexer', 'mixed_case', 'no'); -- no = case sensitive, yes = case insensitive end; |
The custom lexer is specified as an index parameter:
drop index aq_fulltext_index; create index aq_fulltext_index on aq_fulltext(text) indextype is ctxsys.context parameters ('datastore aq_fulltext_uds lexer example_lexer sync(every "sysdate+1/24")'); |
The lexer can also be changed without dropping the index first:
alter index aq_fulltext_index parameters ('replace metadata lexer example_lexer'); alter index aq_fulltext_index rebuild; |
For this option, the following points need to be taken into consideration:
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels. Note: the article itself also appears as related article, this is a known limitation.