When using Universal Search for searching Owner for Cases, GoldMine states "Nothing was found in your search for the specific GoldMine Username"

Version 1

    Details

    When using Universal Search for searching Owner for Cases, GoldMine states "Nothing was found in your search for the specific GoldMine Username"

    [PRE-REQUISITS]
    - To have several cases in the GoldMine system for example with the Owner ANGELAL
    - To have Universal Search installed and working properly


    [STEPS TO REPLICATE]
    1. Go To > Search > Universal Search
    2. Enter the Owner name for example ANGELAL into the Search:
    3. Check the Advanced Check Box
    4. Uncheck All and check instead only Cases (you may need to scroll down)
    5. Click the GO Button

    [RESULT]
    -
    Nothing was found in your search for 'ANGELAL'. (although Cases with the Owner ANGELAL are available)




    Resolution

    [CAUSE/INFORMATION]
    - The GoldMine Universal Search is using the CONTAINSTABLE clause for the search in Microsoft SQL Server in combination with the Full Text  Index columns
    - The OWNER column is not included into the Full Text Index columns, which means that the 'OWNER' field is not searched through, and therefore no results will be found in this specific search

    - This is the current default behavior as searching for an Owner of a Case is not a usual business case, but if this is a 'business critical'  information, the OWNER column can be added to the  Full text / Universal Search Index.
    - Please keep in mind that this should  be documented and the GoldMine administrator or Database administrator  may need to keep in mind every time the Universal Search Full Text  index will be rebuild (for example by uninstalling and reinstalling the  Universal Search) the column needs to be re-added again.

    - Default behavior  (where OWNER field/column is not included in the Full text catalog Cases index)




    - With enabled OWNER field/column from CASES table was added to the Full Text Catalog Index






    [STEPS TO RESOLVE]
    The change of the indexed fields can be done in the

    1. SQL Server Management Studio
    2. Browsing to and expanding the GoldMine database
    3. Storage
    4. Full Text Catalogs
    5. Right click on the Full text catalog of the GoldMine database > Properties
    6. On the Select a page (left top pane) > Tables/Views
    7. On the table/view objects assigned to the catalog > browse to the CASES
    8. Activate OWNER
    9. OK