Is there any out of box configuration that can make the CI search case insenstive.

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    APPLIES TO:

    BMC Remedy AR System Server



    PROBLEM:

    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;


    SOLUTION:

     

    Legacy ID:KA296522

      
       

    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.

     


    Article Number:

    000037827


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles