Bug 19002 - Invoice filters "Shipment date (From):" and "Billing date (From):" don't start with date selected
Summary: Invoice filters "Shipment date (From):" and "Billing date (From):" don't star...
Status: CLOSED WORKSFORME
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: 17.05
Hardware: All All
: P5 - low minor (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-07-28 22:46 UTC by John Sterbenz
Modified: 2020-01-06 20:14 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 John Sterbenz 2017-07-28 22:46:34 UTC
When filtering invoices using "Search filters" on left side of screen, setting the "From:" shipment date does not include results from that date, effectively functioning as a "greater than" limiter instead of a "greater than or equal to" limiter.  I (and, I expect, most users) would expect "greater than or equal to" functionality.

This condition was confirmed true both when only "shipment dates" were used to limit as well as when another criterion (I chose "vendor") was selected.

URL parameters show correct passing of date value in "shipmentdatefrom".


The same conditions and results are true with "Billing date (From):" and its parameters.


Maybe a simple wording change is the fix, ("From" to "After"), though typical usage of date limiters includes, not excludes, the date selected in results sets.


It is unknown if this condition existed in earlier releases.


VERIFY (using Shipment Date):
1)  Using any means at your disposal, learn of any valid shipmentdate value in aqinvoices 
2)  GO TO: Home > Acquisitions > Invoices
3)  Set a limiter for "Shipment date (From:)" using that valid shipmentdate
4)  Observe that no results from that date appear in the results


OTHER DETAILS:
Koha 17.05.01.000 on Ubuntu 14.04 with MySQL 5.5.55, installed and updated via packages. Observed in Chrome 59.0.* and Firefox 53.0.*
Comment 1 Katrin Fischer 2019-02-04 22:10:29 UTC
This appears to have been resolved in a later version. I just tested with the billing and shipping date filters set to the exact date in my invoice and the invoice was found (date inclusive search).