Search field (bug)?

marcinwolejko 23 Mar, 2015
Just a quick question regarding the search field in CC v5.

My connectivity list holds a list of various clients. Their names can sometimes be quite similar, like "Adam Bus" or Adampol".
When you enter the string "Adam: the search results show all clients starting with "Adam"... that's OK. But when you type "Adampol" the result list will also show "Adam Bus" as well as "Adampol".

WIth CC v4 it never happened to me... is this a bug or is there a way to make it work as in the previous version?

Thanks in advance for an answer🙂
marcinwolejko 23 Mar, 2015
:D this faq unfortunately does not answer my question ...
marcinwolejko 23 Mar, 2015
Hmmm.. I debugged the cc v4 and the search result for "adam bus" is
[SQL] => Array
        (
            [0] => SELECT `EWI`.* FROM `database table` AS `EWI` WHERE `EWI`.`kierowca` LIKE '%adam bus%' OR `EWI`.`nr_auta` LIKE '%adam bus%' OR `EWI`.`telefon` LIKE '%adam bus%' OR `EWI`.`firma` LIKE '%adam bus%' OR `EWI`.`name` LIKE '%adam bus%' ORDER BY `cf_created` DESC LIMIT 0,100
        )


While with CC v5
 [2] => SELECT COUNT(`EWI`.`id`) AS `EWI.count` FROM `table` AS `EWI` WHERE ((`EWI`.`firma` LIKE '%adam%') OR (`EWI`.`firma` LIKE '%bus%')) GROUP BY `EWI`.`created`


It seems that the query is being divided into two in the new version......

Any clue how to restore the CC v4 functionality ?🙂
Max_admin 23 Mar, 2015
Hi Marcin,

If you have 2 words then v5 will list results with any of the words, but if you search for "Adampol" then you should not get "Adam bus" in the result, because you only have one word which is "Adampol".

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
marcinwolejko 23 Mar, 2015
Max - thanks for your answer.
Is it possible to have a search form that would somehow merge the search query and load a list of results to show only i.e. Adam Bus (when you type "Adam Bus") and not Adam Transport?
It worked this way in CC4 using LIKE %...%
:(
Max_admin 23 Mar, 2015
Just try this:
"Adam bus"

it will try to match all words between the quotes.
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
marcinwolejko 23 Mar, 2015
If there is no other way to do that I will have to explain to my co-workers that they need to use quotes...
😀 this is going to be hard haha
Max_admin 30 Mar, 2015
Hi Marcin,

Unfortunately there is no way around this for now, I did it this way because this is how Google search works too!🙂

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.