Bug 37249 - Item search column filtering broken
Summary: Item search column filtering broken
Status: Signed Off
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks: 37238
  Show dependency treegraph
 
Reported: 2024-07-03 17:10 UTC by Lucas Gass
Modified: 2024-07-04 01:56 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
Bug 37249: disambiguate itemnumber with USING clause (1.25 KB, patch)
2024-07-03 20:41 UTC, Lucas Gass
Details | Diff | Splinter Review
Bug 37249: disambiguate itemnumber with USING clause (1.30 KB, patch)
2024-07-04 01:56 UTC, Phil Ringnalda
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Lucas Gass 2024-07-03 17:10:22 UTC
To test:

1. Do an item search that returns results 
2. Use the column filtering available at the top of the table for each column 
3. Try itemnumber, get a 500 error each time 
4. As long as there is data in the itemnumber column and you attempt to use another column you'll see a 500 error.

Without anything in the itemnumber column:

5. Try filtering by home library, currently library, item type, or shevling location. 
6. The filtering doesn't work unless you type the code, not the description.
Comment 1 Lucas Gass 2024-07-03 20:41:24 UTC
Created attachment 168478 [details] [review]
Bug 37249: disambiguate itemnumber with USING clause

1. Do an item search that returns results
2. Use the column filtering available at the top of the table for each column
3. Try itemnumber, get a 500 error each time
4. As long as there is data in the itemnumber column and you attempt to use another column you'll see a 500 error.
5. APPLY PATCH, restart_all
6. The itemnumber column filtering should now work as expected
Comment 2 Phil Ringnalda 2024-07-04 01:56:04 UTC
Created attachment 168486 [details] [review]
Bug 37249: disambiguate itemnumber with USING clause

1. Do an item search that returns results
2. Use the column filtering available at the top of the table for each column
3. Try itemnumber, get a 500 error each time
4. As long as there is data in the itemnumber column and you attempt to use another column you'll see a 500 error.
5. APPLY PATCH, restart_all
6. The itemnumber column filtering should now work as expected

Signed-off-by: Phil Ringnalda <phil@chetcolibrary.org>