This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
BMC Remedy AR System Server
Is there any out of box configuration that can make the CI search case insenstive.
This could be when trying to search for CI from Change Request to relate or in AST forms.
BMC Remedy AR System Server (version 7.1.00) DR: AR System Server for Unix;
Oracle is case-sensitive, so all searches done by ARS will be case sensitive. We do have a product called FTS (Full Text Search) which can be used to provide case insensitive searching along with many other features.
Oracle can be configured to do case insensitive searches, but then the indexes that are created by ARS by default will all have to be recreated by the DBA using the same option or else the DB cannot use the indexes.