Remedy AR System Server - How to identify forms which contain fields with FTS indexes at Database level - INCLUDES VIDEO

Version 12
    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:

    Remedy AR System Server


    APPLIES TO:

    BMC Remedy AR System Server



    QUESTION:

    How to identify forms which contain fields with FTS indexes at Database level.
     


    ANSWER:

     

    Run below query using database client 
    ---------------------------------------------------------------------------------
    SELECT a.NAME         "Form Name", 
           a.schemaid     "SchemaId", 
           b.fieldname, 
           b.fieldid, 
           'MFS Category' "Field Type", 
           0 "fulltextoptions", 
           b.overlaygroup 
    FROM   field b 
           JOIN arschema a 
             ON b.schemaid = a.schemaid 
    WHERE  b.objprop LIKE '%60055\4\%' 
    UNION 
    SELECT a.NAME      "Form Name", 
           a.schemaid  "SchemaId", 
           c.fieldname, 
           b.fieldid, 
           'Character' "Field Type", 
           b.fulltextoptions, 
           b.overlaygroup 
    FROM   field_char b 
           JOIN arschema a 
             ON a.schemaid = b.schemaid 
           JOIN field c 
             ON b.schemaid = c.schemaid 
                AND b.fieldid = c.fieldid 
    WHERE  b.fulltextoptions > 0 
    UNION 
    SELECT a.NAME     "Form Name", 
           a.schemaid "SchemaId", 
           c.fieldname, 
           b.fieldid, 
           'Diary'    "Field Type", 
           b.fulltextoptions, 
           b.overlaygroup 
    FROM   field_diary b 
           JOIN arschema a 
             ON a.schemaid = b.schemaid 
           JOIN field c 
             ON b.schemaid = c.schemaid 
                AND b.fieldid = c.fieldid 
    WHERE  b.fulltextoptions > 0 
    UNION 
    SELECT a.NAME       "Form Name", 
           a.schemaid   "SchemaId", 
           c.fieldname, 
           b.fieldid, 
           'Attachment' "Field Type", 
           b.fulltextoptions, 
           b.overlaygroup 
    FROM   field_attach b 
           JOIN arschema a 
             ON a.schemaid = b.schemaid 
           JOIN field c 
             ON b.schemaid = c.schemaid 
                AND b.fieldid = c.fieldid 
    WHERE  b.fulltextoptions > 0 
    UNION 
    SELECT a.NAME     "Form Name", 
           a.schemaid "SchemaId", 
           c.fieldname, 
           b.fieldid, 
           'Table'    "Field Type", 
           b.fulltextoptions, 
           b.overlaygroup 
    FROM   field_table b 
           JOIN arschema a 
             ON a.schemaid = b.schemaid 
           JOIN field c 
             ON b.schemaid = c.schemaid 
                AND b.fieldid = c.fieldid 
    WHERE  b.fulltextoptions > 0 
    ORDER  BY 1,3,5
    ---------------------------------------------------------------------------------


    The full text mode (in the fulltextoptions column) equates to the following:

      

    0   No MFS or FTS  (this is when it's used for MFS Categorization)
    1   FTS and MFS
    5  MFS only

      

     

      

    Example Output:
    User-added image



      

     

      
    Related Products:  
       
    1. BMC Remedy AR System Server

     


    Article Number:

    000202525


    Article Type:

    FAQ/Procedural



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