[Bug 20514] New: Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

newer
[Bug 1985] Email notification of...

bugzilla-daemon＠bugs.koha-community.org

3 Apr 2018 3 Apr '18

10:56 p.m.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 Bug ID: 20514 Summary: Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P4 Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: alexbuckley@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com If inputting a street address of street number and street name which are stored in different db fields (e.g. 'streetnumber' and 'address') this does not return patron results. If however the street number and name are stored in the same db field then results are returned for your search query. At present the only way to search with the search field of address is to either enter ONLY a streetnumber OR a street name unless they are both stored in the same db field. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

Show replies by date

bugzilla-daemon＠bugs.koha-community.org

25 May 25 May

4:05 a.m.

New subject: [Bug 20514] Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 danield@brimbank.vic.gov.au changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |danield@brimbank.vic.gov.au --- Comment #1 from danield@brimbank.vic.gov.au --- Is there any chance of this being patched in 18.05? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

bugzilla-daemon＠bugs.koha-community.org

11 May 11 May

4:25 p.m.

New subject: [Bug 20514] Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

bugzilla-daemon＠bugs.koha-community.org

4:25 p.m.

New subject: [Bug 20514] Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 89609 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89609&action=edit Bug 20514: Use streetnumber when searching for patrons by address The streetnumber field was ignored from the search. Test plan: Create a patron with streetnumber="12", address="rue des cerisiers" Search for patrons using the search field "street address" using: 12 rue des cerisiers => Without this patch the patron will not be returned => With this patch applied it will! -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

bugzilla-daemon＠bugs.koha-community.org

4:26 p.m.

New subject: [Bug 20514] Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |jonathan.druart@bugs.koha-c |ity.org |ommunity.org CC| |jonathan.druart@bugs.koha-c | |ommunity.org -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

bugzilla-daemon＠bugs.koha-community.org

13 May 13 May

2:10 a.m.

New subject: [Bug 20514] Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 Hayley Mapley <hayleymapley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

bugzilla-daemon＠bugs.koha-community.org

2:10 a.m.

New subject: [Bug 20514] Searching for a patron using the search field (street address) returns no results if inputting a address stored in multiple db fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20514 Hayley Mapley <hayleymapley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #89609|0 |1 is obsolete| | --- Comment #3 from Hayley Mapley <hayleymapley@catalyst.net.nz> --- Created attachment 89647 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89647&action=edit Bug 20514: Use streetnumber when searching for patrons by address The streetnumber field was ignored from the search. Test plan: Create a patron with streetnumber="12", address="rue des cerisiers" Search for patrons using the search field "street address" using: 12 rue des cerisiers => Without this patch the patron will not be returned => With this patch applied it will! Signed-off-by: Hayley Mapley <hayleymapley@catalyst.net.nz> -- You are receiving this mail because: You are watching all bug changes.