https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23817
--- Comment #10 from David Cook <[email protected]> --- I think the only way forward is to normalize the data in the database (ie only store [\+0-9], and normalize the search query in "koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc" to [\+0-9] as well. It would still be necessary to update all the patron data in the database. We'd need something like "touch_all_patron_records.pl", or a once off SQL update to strip out everything that isn't [\+0-9]. regexp_replace(phone,'[^0-9]','') would be useful for that. This patch doesn't take into account Katrin's edge cases of multiple phone numbers or text comments in the "phone" field. There's no way to do that unless we completely change how DataTables work with the REST API. I've taken a look at a large patron database and over 99% of phone number data is just 1 phone number. Out of 100,000+ records, I see maybe 5 that have text comments in them. I see 2 records with 2 phone numbers in them. If they need to note the phone number belongs to a particular person or is text only, I think that needs to go in the "Contact note". -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
