[Koha-bugs] [Bug 7544] Add ability search borrowers only on email / phone

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7544

Liz Rea <wizzyrea at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #20 from Liz Rea <wizzyrea at gmail.com> 2012-02-20 16:57:32 UTC ---
Testing notes:

I went through my usual testing for this -- 

Borrower Primary Phone number = (212) 555-1212

Relevant patron data from borrowers:
     borrowernumber: 19
        cardnumber: 23529000035676
           surname: Acevedo III
         firstname: Henry James
           address: 4345 Library Rd.
              city: Springfield, MA
           zipcode: 44224
             email: acevedo at hotmail.com
             phone: (212) 555-1212
            mobile: 222 222 2222
          emailpro: acevedo1 at gmail.com
          phonepro: 111-111-1111
           B_email: acevedo2 at yahoo.com
           B_phone: (333) 333 3333
       dateofbirth: 1958-05-30
        branchcode: MPL
      categorycode: S
      dateenrolled: 1990-09-23
        dateexpiry: 2020-12-31
               sex: F
             flags: 1
            userid: acevedo
   altcontactphone: 444 4444

Works:
Phone:
(212) 555-1212
(212) 555
212 555
555 1212
Email: 
user at host.com 
user

Doesn't work:
555-1212 
5551212 
(333) 333 3333 (this was exactly what was in the db, and didn't work)
2125551212 (the above are important! They have to work!)
212-555 (maybe ok)
Email:
host.com (or anything after the @ sign. Maybe no big deal)

It gets stickier when the phone numbers aren't in (xxx) xxx-xxxx format. 

If we can't make these work, we will need to document that you must, at a
library staff level, define an input pattern and stick to it. That's fine by me
- but I think it would be better if it could also search by last 7.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.