Filter search only works for first letter

I am very new to SuiteCRM, I have created some 100 products, and if I want to filter the product i have to type the first word, then only it gives me the result. If I type any letter in between, it gives me no result.

I have also tried Global search with Lucene, however, it gives me results from any part only for Leads, Accounts, Tasks but not for Products. In the search settings, i have added Products to Enabled Modules section.

Did you try anything else other than this?

With wildcard i can search anything now, however Global search for products is still not working. Global search with Lucene don’t result anything in products.

Is this a correct summary:

Global search (ie top right box)

  • never matches a product - even if
  • the correct whole word is used
  • OR the wildcard is used

EVEN after settings: Admin/ ‘Global Search’ has Products active.

versus 'List page

  • does match - but only IF : correct-whole-word, OR wild-card