cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

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

JensN.
13-Aquamarine

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4

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.
13-Aquamarine
(To: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

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.
13-Aquamarine
(To:JoeBartlett)

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

Top Tags