Keyword

Search Tool can't search number from Drop-down Selection.

  • saovry
  • saovry's Avatar Topic Author
  • Offline
  • New Member
More
1 week 4 days ago #178138 by saovry
Drop-down Selection.
5 Years Old
6 Years Old
7 Years Old
8 Years Old
9 Years Old

If I search "5 Ye", No results found!
If I search " Yea", the result will show. (They can read space but can't read number)

It seems the K2 search can't search the value of numbers from the drop-down selection.

I am using K2 v2.10.4 [Dev Build 20210205]

thank

Could you check it..

thank

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
1 week 4 days ago #178150 by Fotis
This is not a K2 issue actually. It's a setting in the database which by default does not search for anything less than 3 characters. "5 Ye" is 2 words with less than 3 characters length each.

So unless you can modify your database's configuration, you can't do much about this.

But do try searching for "5 Ye" using the double quotes and it'll probably work, as K2 will use the entire string to search in the database (including the space).

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

  • saovry
  • saovry's Avatar Topic Author
  • Offline
  • New Member
More
1 week 4 days ago #178157 by saovry
My database will search with 4 words.
If I search " yea" it will show the result because it is 4 word. The search will start from space to the last letter a. There are 4 word. They will show many results.


In my case I want to search whose is 5 year.
So I will search "5 ye", there is no result. And it is 4 words already. Number 5 is one and letter e is number 4, but for this case K2 search don't search number 5. It starts search from space to letter e. And it is only 3 words.

It is the really problem. I search "5 yea", the search will show many result.. It is wrong for me because I want to search who is 5 years old.

Thank you..

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
1 week 4 days ago #178160 by Fotis
If you don't explicitly use double quotes in your search, the any spaces inbetween words are evaluated as OR statements and any spaces before/after what you type are trimmed.

"yea" is also searched because it's 3 characters.

Like I said, it's a database configuration thing.

For InnoDB it's this: dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_min_token_size
For MyISAM it's this: dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_ft_min_word_len

Pass these on to your server host - they may have no issue adjusting their database config (but I highly doubt they will do so).

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum