[Koha-bugs] [Bug 30533] New: Add exact search option for patrons

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

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

            Bug ID: 30533
           Summary: Add exact search option for patrons
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: andrew at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

A patron search for names like "JOHN JOHNSON" ends up getting parsed something
like "WHERE surname like "%JOHN%" OR firstname like "%JOHN%" OR surname like
"%JOHNSON%" OR firstname like "%JOHNSON%"" and finds a really unhelpfully large
pile of patrons.

Bug 17500 suggests implementing Elastic for patron searching, which would be
great.

In the meantime, we could give a little help for searches like this by giving
an exact search option -- so the query would parse more or less the same but
without the wildcards. That's also a problematic search for many situations,
but would work better here.

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