When searching for records in 3scale tables (account, product, backend...), the Sphinx divides the search word using various separators. When using a keyword that is shorter than 3 characters, Sphinx always returns an empty result. This happens even when searching for a phrase and one word in the phrase is less than 3 characters (even though the remaining words are more than 3 characters. That is, this happens any time a word that has fewer than 3 characters is being used, even when it is used in combination with other keywords, that are equal to or longer than 3 characters.
The following text is part of the original description. It's possible that this particular problem has been fixed already. This should be investigated.
Example: the name "account-1" is a valid name for the 3scale Account. When searching in the accounts table (`/buyers/accounts`) we are able to find this account by typing "account". But using "account-1" as a search key returns zero results. In this case, Sphinx uses "-" as a separator, therefore it identifies two keywords: "account" and "1".
Two account names were generated by the 3scale QE test suite and their representation by Sphinx (from the system-sphinx log).
- "ui_accou-jsmolar-accont-jfpr"
ui_accou\\\-jsmolar\\\-accont\\\-ljnf
- "ui_accou-0-account-jfpr"
org_name\\\-0\\\-serch\\\-r0qn
However, we also have discovered that this failure happens for any phrase that contains a word with fewer than 3 characters for example, "This is our phrase".
Let's find a way to handle this in code in a way that is transparent to the user so that they don't need to know the details of our search beyond what is already currently explained in the UI and the documentation.
- is related to
-
THREESCALE-1028 Validate the length of search strings at Developers and Applications pages in Admin portal
- Closed
- relates to
-
THREESCALE-6332 Table Search on Product and Backend pages does not work correctly (sphinx)
- Closed
-
THREESCALE-11428 Object in 3scale is not searchable if name consist of subpart shorter than 3 characters
- To Develop