Remedy - FTS - How to stop FTS search from using leading and trailing wildcard

Version 4
    Share This:

    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


    COMPONENT:

    AR System


    APPLIES TO:

    Remedy AR System Full Text Search (FTS) - All versions.



    PROBLEM:

    How the configuration can be changed so wild cards are no used when performing a FTS Search?

    The AR System Full Text Search (FTS) performs a leading and trailing wildcard search.
    For example using the search term 'Thursday evening':

    The logs show:
    ...................
    */FTS: Search request for schema ID 2986, field ID 777031007, search term ((
    %Thursday% %evening%))
    */FTS: Found 1 entry

    ...................

    Checking in the application configuration side:

    1- In DevStudio the related configured field for FTS is set as:

         User-added image



    2- In the Administration Console > Server Information > FTS this settings is set:
        Search Options = Query Unchanged

         User-added image


     


    CAUSE:

    The QBE option for FTS needs to be set correctly to accomplish this scenario.


    SOLUTION:

    Perform the following:
    In DevStudio in the FTS field's properties, change the QBE Match value from 'Anywhere' to 'Equal'.

         User-added image


    References:
    Using the query-by-example method
    Remedy - FTS - How does the QBE Match affect searching a FTS indexed field?


    Article Number:

    000183952


    Article Type:

    Solutions to a Product Problem



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