https://bugs.kde.org/show_bug.cgi?id=361625
Bug ID: 361625 Summary: Tellico ("Video Collection") - Date field filter bugs Product: tellico Version: 2.3.9 Platform: Other OS: Linux Status: UNCONFIRMED Severity: normal Priority: NOR Component: general Assignee: ro...@periapsis.org Reporter: ejr2...@mybtinternet.com Created attachment 98337 --> https://bugs.kde.org/attachment.cgi?id=98337&action=edit Example database and screen-shots Version: 2.3.9 4.14.15, Kubuntu packages OS: Linux (x86_64) release 4.2.0-35-generic Compiler: x86_64-linux-gnu-gcc Hi, I am reporting here two bugs in relation to filtering on "Date" fields in a Video Collection. I believe they are unrelated, but who knows, maybe they are. Please see example database attached (but they are easily reproducible - you should be able to get the same behaviour if you create your own database). I have added an additional "custom" date field, which I've called "My Date" (through Collection > Collection Fields). This could be used for instance for "Last time movie was watched" or "Date when DVD purchased" or whatever... I am making the distinction below between this "custom date" field, and "standard date" fields, such as "Date Created" and "Date Modified". I have created two entries (one would suffice, actually - there is no need for two entries to see the bugs) both with "My Date" = 2016-01-02 (2nd Jan 2016) and "Date Created" = 2016-04-11 (11th Apr 2016) I have also created 5 filters: - "After" - Filter on "My Date" "is after" 01/01/2016 - "Before" - Filter on "My Date" "is before" "01/01/2017" - "Created-After" - Filter on "Date Created" "is after" 01/01/2016 - "Created-Before" - Filter on "Date Created" "is before" "01/01/2017" - "Equals" - Filter of "My Date" "equals" "02/01/2016" (2nd Jan 2016) Please note that, based on the data above, all 5 filters should find 2 matching records. BUG #1: ----------- You can check that the filters have been created as described above (with the criterion being "is after" or "is before" as described) in the xml file provided. You may also want to create your own filters to double-check. Regardless of the filter, whenever I double-click on it (or Right-Click > Modify Filter), the window that opens shows the criterion as "equals" and not "is before" or "is after" as the filter was created. Please see attached screen-shot for filter "After". This is true for all four "before" or "after" filters. BUG #2: ----------- The three filters "Created-After", "Created-Before" and "Equals" work correctly - all three correctly find two matching records. The two filters "After" and "Before" (which filter based on the "custom date") do not work correctly. They fail to find the two records that should match the criterion ("My Date" being before or after the set date - in both cases, the criterion should be met). Please see attached screen-shot. I am therefore led to believe this bug affects only "custom" (not "standard") date fields, and only when the criterion is "is before" or "is after". -- You are receiving this mail because: You are watching all bug changes.