Bug 438960 - Add support for searching images created in a time interval
Summary: Add support for searching images created in a time interval
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Searches-Advanced (show other bugs)
Version: 7.5.0
Platform: Appimage Linux
: NOR wishlist
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-06-20 19:02 UTC by Johannes
Modified: 2022-10-03 07:04 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 8.0.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Johannes 2021-06-20 19:02:59 UTC
Searching for pictures created in a time range returns all images.

STEPS TO REPRODUCE
1. Create an Advanced Search with Picture Properties > Date > Return items created between 09:00 and 10:00
2. Click OK

OBSERVED RESULT
All images from digiKam are a shown.

Logging output with export QT_LOGGING_RULES="digikam*=true";
 Digikam::ItemLister::listSearch: Search query:
 "SELECT DISTINCT Images.id, Images.name, Images.album,        Albums.albumRoot,        ImageInformation.rating, Images.category,        ImageInformation.format, ImageInformation.creationDate,        Images.modificationDate, Images.fileSize,        ImageInformation.width, ImageInformation.height,        ImagePositions.latitudeNumber, ImagePositions.longitudeNumber  FROM Images        LEFT JOIN ImageInformation ON Images.id=ImageInformation.imageid        LEFT JOIN ImageMetadata    ON Images.id=ImageMetadata.imageid        LEFT JOIN VideoMetadata    ON Images.id=VideoMetadata.imageid        LEFT JOIN ImagePositions   ON Images.id=ImagePositions.imageid        INNER JOIN Albums          ON Albums.id=Images.album WHERE Images.status=1 AND (  ( 1 )  );" 
 ()
 


EXPECTED RESULT

Only images created between 9 and 10 o'clock are shown.



SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Ubuntu Linux 18.04.05

KDE Frameworks 5.78.0
Qt 5.14.2 (built against 5.14.2)


ADDITIONAL INFORMATION
Useful for example in combination with 
Month/Day Return items from a month or a day of the month.
Comment 1 Maik Qualmann 2021-06-20 20:50:39 UTC
This date search area also requires a date, only setting a time is not valid. There is currently no search option just for the time.

Maik
Comment 2 caulier.gilles 2021-07-19 06:53:45 UTC
With next digiKam 7.4.0 release, AppImage bundle is compiled using a more recent Linux Mageia 7.1 host. Last stable Qt 5.15.2 and KF5 5.84 are used. ImageMagick codec 7 and libav 58 (ffmpeg) are used to supports extra image and video formats.

https://i.imgur.com/XV1tZkL.png

Please check if problem still reproducible with this version available as pre-release here:

https://files.kde.org/digikam/

Gilles Caulier
Comment 3 Maik Qualmann 2022-10-03 07:04:19 UTC
A time range search is now available in digiKam-8.0.0.

https://invent.kde.org/graphics/digikam/-/commit/3150bcb3526738f51c3e6e61c50e07c40b828edf

Maik