[Koha-bugs] [Bug 15268] New: Patron search differs between 'Check out' search and 'Patron' search on two-word surnames like 'St. Claire'

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

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

            Bug ID: 15268
           Summary: Patron search differs between 'Check out' search and
                    'Patron' search on two-word surnames like 'St. Claire'
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Circulation
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

Given Patrons with the following names:

SURNAME    , FIRSTNAME

ST CLAIRE  , JAKE
ST. AUBIN  , SHELLEY P
ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  
ST. JOHN   , CHRISTA
ST. JOHN   , EMERSON D
STEINBERG  , CLAIRE

The patron search and checkout search behave differently:

Searching for

  st. claire

Patron search returns

ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  

check-out search returns nothing.

---

Searching for

  st claire

Patron search returns results for both ST CLAIRE and ST. CLAIRE:

ST CLAIRE  , JAKE
ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  

check-out search returns STEINBERG   , CLAIRE

---

Searching for

  st.

Both searches return

ST. AUBIN  , SHELLEY P
ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  
ST. JOHN   , CHRISTA
ST. JOHN   , EMERSON D

This may be related to Bug 7397 - Patron search from Checkout tab does
'contains' instead of 'starts_with' search.

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