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.

Reply via email to