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

[JensN.]

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

[JoeBartlett · Accepted solution]

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.

[JensN.]

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

[JoeBartlett]

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.

[JensN.]

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