Capital letter in search function

verzevoul

Member
Is there a way to include capital and small caps in the results of search.
When I use search all only the exact comes as results. I have checked if exact match to no.

I use greek characters.

Thanks!
 
I think "exact match" is only concerning substrings (should a find abc).

Search all should be case insensitive but depending on which elements are included in search all it may switch to case sensitive.

Can you enable fabrikdebug (in fabrik options) and append &fabrikdebug=1 to your URL?
Can you post (the end of) the query which you'll see if clicking on list GetData?
 
list GetData:???????? ????????????
SELECT SQL_CALC_FOUND_ROWS DISTINCT `1_epikoinonias`.`id` AS `1_epikoinonias___id`, `1_epikoinonias`.`id` AS `1_epikoinonias___id_raw`, `1_epikoinonias`.`date_time` AS `1_epikoinonias___date_time`, `1_epikoinonias`.`date_time` AS `1_epikoinonias___date_time_raw`, `1_epikoinonias`.`Eponimia` AS `1_epikoinonias___Eponimia`, `1_epikoinonias`.`Eponimia` AS `1_epikoinonias___Eponimia_raw`, `1_epikoinonias`.`onoma` AS `1_epikoinonias___onoma`, `1_epikoinonias`.`onoma` AS `1_epikoinonias___onoma_raw`, `1_epikoinonias`.`eponimo` AS `1_epikoinonias___eponimo`, `1_epikoinonias`.`eponimo` AS `1_epikoinonias___eponimo_raw`, `1_epikoinonias`.`field_contact_person` AS `1_epikoinonias___field_contact_person`, `1_epikoinonias`.`field_contact_person` AS `1_epikoinonias___field_contact_person_raw`, `1_epikoinonias`.`tilefono` AS `1_epikoinonias___tilefono`, `1_epikoinonias`.`tilefono` AS `1_epikoinonias___tilefono_raw`, `1_epikoinonias`.`tilefono_stethero2` AS `1_epikoinonias___tilefono_stethero2`, `1_epikoinonias`.`tilefono_stethero2` AS `1_epikoinonias___tilefono_stethero2_raw`, `1_epikoinonias`.`fax` AS `1_epikoinonias___fax`, `1_epikoinonias`.`fax` AS `1_epikoinonias___fax_raw`, `1_epikoinonias`.`field_kinitotil` AS `1_epikoinonias___field_kinitotil`, `1_epikoinonias`.`field_kinitotil` AS `1_epikoinonias___field_kinitotil_raw`, `1_epikoinonias`.`field_imerominia_rantevou` AS `1_epikoinonias___field_imerominia_rantevou`, `1_epikoinonias`.`field_imerominia_rantevou` AS `1_epikoinonias___field_imerominia_rantevou_raw`, `1_epikoinonias`.`field_imerominia_rantevou_tilefonikou` AS `1_epikoinonias___field_imerominia_rantevou_tilefonikou`, `1_epikoinonias`.`field_imerominia_rantevou_tilefonikou` AS `1_epikoinonias___field_imerominia_rantevou_tilefonikou_raw`, `1_epikoinonias`.`admin_visible_name_` AS `1_epikoinonias___admin_visible_name_`, `1_epikoinonias`.`admin_visible_name_` AS `1_epikoinonias___admin_visible_name__raw`, `1_epikoinonias`.`field_source` AS `1_epikoinonias___field_source`, `1_epikoinonias`.`field_source` AS `1_epikoinonias___field_source_raw`, `1_epikoinonias`.`field_category` AS `1_epikoinonias___field_category`, `1_epikoinonias`.`field_category` AS `1_epikoinonias___field_category_raw`, `1_epikoinonias`.`dieythinis` AS `1_epikoinonias___dieythinis`, `1_epikoinonias`.`dieythinis` AS `1_epikoinonias___dieythinis_raw`, `1_epikoinonias`.`tk` AS `1_epikoinonias___tk`, `1_epikoinonias`.`tk` AS `1_epikoinonias___tk_raw`, `1_epikoinonias`.`field_area` AS `1_epikoinonias___field_area`, `1_epikoinonias`.`field_area` AS `1_epikoinonias___field_area_raw`, `1_epikoinonias`.`paratiriseis_rantevou` AS `1_epikoinonias___paratiriseis_rantevou`, `1_epikoinonias`.`paratiriseis_rantevou` AS `1_epikoinonias___paratiriseis_rantevou_raw`, `1_epikoinonias`.`field_email` AS `1_epikoinonias___field_email`, `1_epikoinonias`.`field_email` AS `1_epikoinonias___field_email_raw`, `1_epikoinonias`.`field_website` AS `1_epikoinonias___field_website`, `1_epikoinonias`.`field_website` AS `1_epikoinonias___field_website_raw`, `1_epikoinonias`.`field_afm` AS `1_epikoinonias___field_afm`, `1_epikoinonias`.`field_afm` AS `1_epikoinonias___field_afm_raw`, `1_epikoinonias`.`field_doy` AS `1_epikoinonias___field_doy`, `1_epikoinonias`.`field_doy` AS `1_epikoinonias___field_doy_raw`, `1_epikoinonias`.`sep_for_change_line` AS `1_epikoinonias___sep_for_change_line`, `1_epikoinonias`.`sep_for_change_line` AS `1_epikoinonias___sep_for_change_line_raw`, `1_epikoinonias`.`eidos_kataxorisis` AS `1_epikoinonias___eidos_kataxorisis`, `1_epikoinonias`.`eidos_kataxorisis` AS `1_epikoinonias___eidos_kataxorisis_raw`, `1_epikoinonias`.`country` AS `1_epikoinonias___country`, `1_epikoinonias`.`country` AS `1_epikoinonias___country_raw`, `1_epikoinonias`.`politis_visible_name_` AS `1_epikoinonias___politis_visible_name_`, `1_epikoinonias`.`politis_visible_name_` AS `1_epikoinonias___politis_visible_name__raw`, `1_epikoinonias`.`politis` AS `1_epikoinonias___politis_raw`, `tuo4k_users`.`name` AS `1_epikoinonias___politis`, `1_epikoinonias`.`id` AS slug , `1_epikoinonias`.`id` AS `__pk_val` FROM `1_epikoinonias` LEFT JOIN `#__users` AS `tuo4k_users` ON `tuo4k_users`.`id` = `1_epikoinonias`.`politis` WHERE ( 1_epikoinonias.politis_visible_name_ = '112' OR `tuo4k_users`.`id` = '112' OR ( 1_epikoinonias.admin_visible_name_ = '112' ) ) AND ( ( `1_epikoinonias`.`Eponimia` REGEXP '??????? ??????' OR `1_epikoinonias`.`onoma` REGEXP '??????? ??????' OR `1_epikoinonias`.`tilefono` REGEXP '??????? ??????' OR `1_epikoinonias`.`tilefono_stethero2` REGEXP '??????? ??????' OR `1_epikoinonias`.`field_kinitotil` REGEXP '??????? ??????' OR `1_epikoinonias`.`field_website` REGEXP '??????? ??????' OR `1_epikoinonias`.`eidos_kataxorisis` REGEXP '??????? ??????' ) ) ORDER BY `1_epikoinonias`.`field_imerominia_rantevou_tilefonikou` DESC
 
Hmm, I can replicate this by inserting ?????? and ?????? in a local list,
it seems REGEXP doesn't handle such characters as "equal if case insensitiv"

It's the same with German umlaute e.g. ? and ?.
:confused:
 
Nope.
I believe I did correctly the update but again, it can t find it.

list GetData:???????? ????????????
SELECT SQL_CALC_FOUND_ROWS DISTINCT `1_epikoinonias`.`id` AS `1_epikoinonias___id`, `1_epikoinonias`.`id` AS `1_epikoinonias___id_raw`, `1_epikoinonias`.`date_time` AS `1_epikoinonias___date_time`, `1_epikoinonias`.`date_time` AS `1_epikoinonias___date_time_raw`, `1_epikoinonias`.`Eponimia` AS `1_epikoinonias___Eponimia`, `1_epikoinonias`.`Eponimia` AS `1_epikoinonias___Eponimia_raw`, `1_epikoinonias`.`onoma` AS `1_epikoinonias___onoma`, `1_epikoinonias`.`onoma` AS `1_epikoinonias___onoma_raw`, `1_epikoinonias`.`eponimo` AS `1_epikoinonias___eponimo`, `1_epikoinonias`.`eponimo` AS `1_epikoinonias___eponimo_raw`, `1_epikoinonias`.`field_contact_person` AS `1_epikoinonias___field_contact_person`, `1_epikoinonias`.`field_contact_person` AS `1_epikoinonias___field_contact_person_raw`, `1_epikoinonias`.`tilefono` AS `1_epikoinonias___tilefono`, `1_epikoinonias`.`tilefono` AS `1_epikoinonias___tilefono_raw`, `1_epikoinonias`.`tilefono_stethero2` AS `1_epikoinonias___tilefono_stethero2`, `1_epikoinonias`.`tilefono_stethero2` AS `1_epikoinonias___tilefono_stethero2_raw`, `1_epikoinonias`.`fax` AS `1_epikoinonias___fax`, `1_epikoinonias`.`fax` AS `1_epikoinonias___fax_raw`, `1_epikoinonias`.`field_kinitotil` AS `1_epikoinonias___field_kinitotil`, `1_epikoinonias`.`field_kinitotil` AS `1_epikoinonias___field_kinitotil_raw`, `1_epikoinonias`.`field_imerominia_rantevou` AS `1_epikoinonias___field_imerominia_rantevou`, `1_epikoinonias`.`field_imerominia_rantevou` AS `1_epikoinonias___field_imerominia_rantevou_raw`, `1_epikoinonias`.`field_imerominia_rantevou_tilefonikou` AS `1_epikoinonias___field_imerominia_rantevou_tilefonikou`, `1_epikoinonias`.`field_imerominia_rantevou_tilefonikou` AS `1_epikoinonias___field_imerominia_rantevou_tilefonikou_raw`, `1_epikoinonias`.`admin_visible_name_` AS `1_epikoinonias___admin_visible_name_`, `1_epikoinonias`.`admin_visible_name_` AS `1_epikoinonias___admin_visible_name__raw`, `1_epikoinonias`.`field_source` AS `1_epikoinonias___field_source`, `1_epikoinonias`.`field_source` AS `1_epikoinonias___field_source_raw`, `1_epikoinonias`.`field_category` AS `1_epikoinonias___field_category`, `1_epikoinonias`.`field_category` AS `1_epikoinonias___field_category_raw`, `1_epikoinonias`.`dieythinis` AS `1_epikoinonias___dieythinis`, `1_epikoinonias`.`dieythinis` AS `1_epikoinonias___dieythinis_raw`, `1_epikoinonias`.`tk` AS `1_epikoinonias___tk`, `1_epikoinonias`.`tk` AS `1_epikoinonias___tk_raw`, `1_epikoinonias`.`field_area` AS `1_epikoinonias___field_area`, `1_epikoinonias`.`field_area` AS `1_epikoinonias___field_area_raw`, `1_epikoinonias`.`paratiriseis_rantevou` AS `1_epikoinonias___paratiriseis_rantevou`, `1_epikoinonias`.`paratiriseis_rantevou` AS `1_epikoinonias___paratiriseis_rantevou_raw`, `1_epikoinonias`.`field_email` AS `1_epikoinonias___field_email`, `1_epikoinonias`.`field_email` AS `1_epikoinonias___field_email_raw`, `1_epikoinonias`.`field_website` AS `1_epikoinonias___field_website`, `1_epikoinonias`.`field_website` AS `1_epikoinonias___field_website_raw`, `1_epikoinonias`.`field_afm` AS `1_epikoinonias___field_afm`, `1_epikoinonias`.`field_afm` AS `1_epikoinonias___field_afm_raw`, `1_epikoinonias`.`field_doy` AS `1_epikoinonias___field_doy`, `1_epikoinonias`.`field_doy` AS `1_epikoinonias___field_doy_raw`, `1_epikoinonias`.`sep_for_change_line` AS `1_epikoinonias___sep_for_change_line`, `1_epikoinonias`.`sep_for_change_line` AS `1_epikoinonias___sep_for_change_line_raw`, `1_epikoinonias`.`eidos_kataxorisis` AS `1_epikoinonias___eidos_kataxorisis`, `1_epikoinonias`.`eidos_kataxorisis` AS `1_epikoinonias___eidos_kataxorisis_raw`, `1_epikoinonias`.`country` AS `1_epikoinonias___country`, `1_epikoinonias`.`country` AS `1_epikoinonias___country_raw`, `1_epikoinonias`.`politis_visible_name_` AS `1_epikoinonias___politis_visible_name_`, `1_epikoinonias`.`politis_visible_name_` AS `1_epikoinonias___politis_visible_name__raw`, `1_epikoinonias`.`politis` AS `1_epikoinonias___politis_raw`, `tuo4k_users`.`name` AS `1_epikoinonias___politis`, `1_epikoinonias`.`id` AS slug , `1_epikoinonias`.`id` AS `__pk_val` FROM `1_epikoinonias` LEFT JOIN `#__users` AS `tuo4k_users` ON `tuo4k_users`.`id` = `1_epikoinonias`.`politis` WHERE ( 1_epikoinonias.politis_visible_name_ = '112' OR `tuo4k_users`.`id` = '112' OR ( 1_epikoinonias.admin_visible_name_ = '112' ) ) AND ( ( `1_epikoinonias`.`Eponimia` REGEXP '????????????' OR `1_epikoinonias`.`onoma` REGEXP '????????????' OR `1_epikoinonias`.`eponimo` REGEXP '????????????' OR `1_epikoinonias`.`tilefono` REGEXP '????????????' OR `1_epikoinonias`.`tilefono_stethero2` REGEXP '????????????' OR `1_epikoinonias`.`field_kinitotil` REGEXP '????????????' OR `1_epikoinonias`.`field_website` REGEXP '????????????' OR `1_epikoinonias`.`eidos_kataxorisis` REGEXP '????????????' ) ) ORDER BY `1_epikoinonias`.`field_imerominia_rantevou_tilefonikou` DESC
 
Same as verzevoul.
For example if I do a search on the word "DESCRIPTION" or "Description" I can not find the word "description".
To find "description" requires that the write exactly like that.
This is true for internal research in fabrik but also for the Fabrik search plugin in joomla.
I updated today with gtihub but it does not work.
 
Sorry but with the yesterday s update I have a problem, adding an element.

Fatal error: Access level to plgFabrik_ElementCascadingdropdown::_buildQuery() must be public (as in class plgFabrik_ElementDatabasejoin) in ...../public_html/plugins/fabrik_element/cascadingdropdown/cascadingdropdown.php on line 1055
 
Maybe the github update isnt correctrly installed. When I update the component fabrik, I get

Scanning /home/webintel/public_html/components/com_fabrik/models/element.php:
# Regular expression match = [decode regex: 1]:
'/home/webintel/public_html/components/com_fabrik/models/element.php'
 
Fatal error: Access level to plgFabrik_ElementCascadingdropdown::_buildQuery() must be public (as in class plgFabrik_ElementDatabasejoin) in ...../public_html/plugins/fabrik_element/cascadingdropdown/cascadingdropdown.php on line 1055

Perhaps you didnt update all the files, for me both the cdd and databasejoin elemnents _buildQuery() methods are protected

Scanning /home/webintel/public_html/components/com_fabrik/models/element.php:
# Regular expression match = [decode regex: 1]:
'/home/webintel/public_html/components/com_fabrik/models/element.php'
Thats a different thing, as far as I can tell its a false positive in some sort of security scan software that some sites have installed.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top