Skip to main content
J
JensN.1-Visitor
1-Visitor
February 6, 2014
Solved

[IM] searching for text in richtextfields, when text is in tables

  • February 6, 2014
  • 2 replies
  • 2236 views

Hi @all,

our users have some queries which fulltext-search in longtext-fields. Some of these fields are richttext-fields, and the text, which the user is searching for, is inside tables. If this is the case, the query doesnt find the text. Is this a bug, or do we have to change our way to search?

Thanks,

kind regards, Jens

    Best answer by JoeBartlett

    The text search functionality should work to find text in tables since rich text fields just get translated into HTML code behind the scenes, which would keep the text values. Are you using an Oracle database? If so, it may take a few minutes for the database text indexes to update with the new text entered into the item. So if users add text to a table and then do a search immediately, they will not see the item returned in the results until that update in Oracle happens. If you are using MS SQL Server, then there is a problem because that should update its text indexes almost instantly.

    I would suggest opening a case with PTC Support if there are ongoing problems with the text searching.

    2 replies

    J
    JoeBartlett21-Topaz IAnswer
    21-Topaz I
    February 6, 2014

    The text search functionality should work to find text in tables since rich text fields just get translated into HTML code behind the scenes, which would keep the text values. Are you using an Oracle database? If so, it may take a few minutes for the database text indexes to update with the new text entered into the item. So if users add text to a table and then do a search immediately, they will not see the item returned in the results until that update in Oracle happens. If you are using MS SQL Server, then there is a problem because that should update its text indexes almost instantly.

    I would suggest opening a case with PTC Support if there are ongoing problems with the text searching.

    J
    JensN.1-VisitorAuthor
    1-Visitor
    February 10, 2014

    Hi,

    thanks for your answer. And like you describes it, it seems to be that we just didnt wait long enough. We have an oracle-db behind our integrity, and after 5 minues or so, the search is finding any text in tables. So wie have to talk to our oracle-db-admins how to avoid such long indexing times.

    kind regards, Jens

    J
    JoeBartlett21-Topaz I
    21-Topaz I
    February 10, 2014

    Integrity has a configurable setting in the Admin Client for how often text indexes update. Look under Workflows and Documents > Configuration > Properties and look for mksis.im.contextSearchSync. The default value is 180 seconds so Integrity tells the Oracle text indexes to update every 3 minutes. The minimum value is 60 seconds, but you may still want to speak with your DBA team to determine how long the database takes to complete the updates once started because setting indexes to update more frequently than they can complete may cause performance issues.

    J
    JensN.1-VisitorAuthor
    1-Visitor
    February 13, 2014

    Hi,

    thanks, we will look what the best balance between waiting time and db-load is. Probably it will stay as it was

    kind regards, Jens

    Terms & ConditionsAccessibility statement