Bug 789 - Cannot search for member by last name, first name
Summary: Cannot search for member by last name, first name
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 2.0.0
Hardware: All All
: P2 major (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-06-10 07:37 UTC by Owen Leonard
Modified: 2023-01-16 14:46 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-20 23:35:17 UTC


---- Reported by oleonard@myacpl.org 2004-06-10 07:37:07 ----

Latest versions of Koha (both rel_2_0 and HEAD) will return no results for a
member search by "lastname, firstname" even if the name is in the database. It
doesn't matter if the first name is full or partial. Searches will only return
results for last names.

The solution needs to no only allow one to search for members by inputting
searches for names with single last names likes "Smith, John" but also
multiple-word last names like "Van Dyke, John."



---- Additional Comments From mjr@ttllp.co.uk 2004-07-01 01:37:53 ----

No data loss or crash. Downgrading to major.

Maybe the split() in modules/C4/Search.pm:1895 should split on ', ' instead of '
'? Please let me know.




---- Additional Comments From oleonard@myacpl.org 2004-07-01 02:50:56 ----

As I recall, the solution that Chris and I discussed hinged on requiring a comma
between first and last names.  Maybe Chris can confirm.  I don't have any
problem with requiring the comma.



---- Additional Comments From st.hedges@gmail.com 2004-09-06 10:43:16 ----

changed member.pl (removed commas from search string) and Search.pm
BornameSearch function (in HEAD).



---- Additional Comments From mjr@ttllp.co.uk 2004-09-06 11:53:13 ----

Believe unfixed in 2.0: can you provide patchfile of the HEAD fix, please?




---- Additional Comments From mjr@ttllp.co.uk 2004-10-30 08:42:14 ----

Patchfile received. Will include in 2.0.2.




--- Bug imported by chris@bigballofwax.co.nz 2010-05-20 23:35 UTC  ---

This bug was previously known as _bug_ 789 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=789

Actual time not defined. Setting to 0.0
The original assignee of this bug does not have
   an account here. Reassigning to the default assignee
   for the component, gmcharlt@gmail.com.
   Previous assignee was mjr@ttllp.co.uk.