Skip to main content
Solved

What are intended use of the Full-Text index option?

  • May 28, 2024
  • 1 reply
  • 50 views

Looking at ways to increase the performance of search options being used by users, the index option “full-text” crossed my eyes. Reading up on what it does and how it works, I am not entirely sure what the intended purpose is in the Thinkwise product.

I was hoping I could use it for the combined filter, but those make “LIKE” statements on the view/tabel it is used on and for full-text it needs “CONTAINS”.

Could someone enlighten me?

I am also open to hear about cases where someone has used the full-text in his/her functionality to get an idea of how it might benefit.

Best answer by Anne Buit

Hi Mark,

Currently, the full-text index can only be used in views and application logic.

The solution proposed by the following idea would allow for combined filter input to be mapped into a CONTAINS clause.

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

1 reply

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 653 replies
  • Answer
  • May 28, 2024

Hi Mark,

Currently, the full-text index can only be used in views and application logic.

The solution proposed by the following idea would allow for combined filter input to be mapped into a CONTAINS clause.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings