https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38671 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |andrew@bywatersolutions.com --- Comment #1 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- The three fields you mention are all datetimes rather than just dates and most of the options here are just checking = / !=. That seems like it will confuse people -- they'll search for itemlost_on='2024-12-11' and not find anything because the actual value is '2024-12-11 14:39:24.' We could add a hint here that suggests one might want to use % after a date. Or we could make the search just compare to the date alone, ignoring the time. The former seems more accurate. The latter seems more friendly to a novice user. Thoughts? -- 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=38671 --- Comment #3 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- (In reply to hebah from comment #2)

I did ponder the complication of the datetime issue.

Which is to say - I initially thought of it as simply adding the columns to the display without making it a search parameter for that reason.

But to be added as a search parameter, I think only searching the date would be the most librarian-friendly, with folks who need more granularity there able to do so from report.

Oh! I misunderstood your request; lemme look at getting those columns available in results. -- 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=38671 --- Comment #4 from Lucas Gass (lukeg) <lucas@bywatersolutions.com> --- If we just want this in the results table, awesome. I do think it would be beneficial to be able to search ON those fields also, like datelastborrowed currently. I filed this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38681 I think having a datepicker is nicer for staff and also make it easier to deal with datetime. -- 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=38671 hebah@bywatersolutions.com changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add fields to item search - |Add fields to item search |lost_on, withdrawn_on, |and item search results |damaged_on |table - lost_on, | |withdrawn_on, damaged_on -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.