[Bug 42647] New: Search by patron attribute using "starts with" fails if attribute value has a space
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 Bug ID: 42647 Summary: Search by patron attribute using "starts with" fails if attribute value has a space Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: oleonard@myacpl.org QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle@bywatersolutions.com The patron search by attribute fails if the attribute value contains a space. This is specific to a "Starts with" search which is the default in patron searches. If you switch to "contains" the patron attribute search works correctly. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |johanna.raisa@koha-suomi.fi Status|NEW |Needs Signoff Assignee|koha-bugs@lists.koha-commun |johanna.raisa@koha-suomi.fi |ity.org | --- Comment #1 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- Created attachment 199371 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199371&action=edit Bug 42647: Fix search by patron attribute using "starts with" and space in attribute value This patch fixes the search by patron attribute using "starts with" operator when the attribute value contains spaces. Test plan: 1. Add a new searchable patron attribute. 2. Add a value for the patron attribute with space in it (e.g., "John Doe") to a patron record. 3. Go to the patron search page. 4. Select patron attribute as the search field and "starts with" as the search operator. 5. Enter a value for the patron attribute with space in it (e.g., "John Doe") and perform the search. 6. Verify that the search result fails. 7. Apply the patch. 8. Repeat steps 1-5. 9. Verify that the search result is correct and includes patrons with the specified attribute value. Sponsored-by: Koha-Suomi Oy -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Sponsorship status|--- |Sponsored -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Comma delimited| |Koha-Suomi Oy list of Sponsors| | Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #199371|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 --- Comment #2 from David Nind <david@davidnind.com> --- Created attachment 199383 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199383&action=edit Bug 42647: Fix search by patron attribute using "starts with" and space in attribute value This patch fixes the search by patron attribute using "starts with" operator when the attribute value contains spaces. Test plan: 1. Add a new searchable patron attribute. 2. Add a value for the patron attribute with space in it (e.g., "John Doe") to a patron record. 3. Go to the patron search page. 4. Select patron attribute as the search field and "starts with" as the search operator. 5. Enter a value for the patron attribute with space in it (e.g., "John Doe") and perform the search. 6. Verify that the search result fails. 7. Apply the patch. 8. Repeat steps 1-5. 9. Verify that the search result is correct and includes patrons with the specified attribute value. Sponsored-by: Koha-Suomi Oy Signed-off-by: David Nind <david@davidnind.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42647 Lucas Gass (lukeg) <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas@bywatersolutions.com Status|Signed Off |Failed QA --- Comment #3 from Lucas Gass (lukeg) <lucas@bywatersolutions.com> --- This fixes the problem when the attribute has a space but the problem remains when the attribute has a comma, I tested with "john, doe". Also, I think changes to the patron search should be covered with a Cypress test. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org