[Koha-bugs] [Bug 23817] Normalize phone number when searching patrons

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23817

--- Comment #6 from David Cook <dcook at prosentient.com.au> ---
(In reply to Katrin Fischer from comment #5)
> If we are changing how search works, I think it's valid to think about edge
> cases. The field is not used for anything by Koha currently in most cases
> (phone notifications are not a thing at all around here). So there is
> nothing to stop people from entering different formats and often notes too.

Indeed it looks like we've only added validation to the "smsalertnumber" and
not the other phone fields. 

But I'd say that's a bug rather than a feature. Something to be removed rather
than accommodated. 

The current phone search is fundamentally broken. 

If you've stored the number as "0412 345 678", you'll never retrieve the record
if you input "0412345678" or "(04)12 345 678" or any other format. 

I'll upload my patch, and then folk can decide what they want to do about it.
But in my opinion, every telephone database field should only contain 1 value.
If people need multiple phone numbers or notes, then they need a new feature
with a denormalized contact table.

-- 
You are receiving this mail because:
You are watching all bug changes.