Remedy - FTS - How to find all fields on which forms are configured for FTS search?

Version 1
    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


    COMPONENT:

    AR System


    APPLIES TO:

    BMC Remedy AR System Server



    QUESTION:

    How to find what all fields on which forms are configured for FTS search? Is there any way to find it out on AR System Server level?


    ANSWER:

     

    Legacy ID:KA377699

    There is no easy method to find what all fields on which forms are enabled for FTS search.
    Running below queries on the database should give the needed information.

    Those are the four tables for the four types of fields that can be full text index enabled.

    Results from these queries provides the list of fields that has some FTS property set.


    select schemaId, fieldId from field_char where fullTextOptions is not null and fullTextOptions != 0
    select schemaId, fieldId from field_diary where fullTextOptions is not null and fullTextOptions != 0
    select schemaId, fieldId from field_attach where fullTextOptions is not null and fullTextOptions != 0
    select schemaId, fieldId from field_table where fullTextOptions is not null and fullTextOptions != 0

      

     

     


    Article Number:

    000030029


    Article Type:

    FAQ/Procedural



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