https://bugs.kde.org/show_bug.cgi?id=428545
Bug ID: 428545
Summary: Wish: Writing SQL query in Advanced Search or Access
to all fields of the database in Advanced Search
Product: digikam
Version: unspecified
Platform: Other
OS: All
Status: REPORTED
Severity: normal
Priority: NOR
Component: Searches-Advanced
Assignee: digikam-bugs-n...@kde.org
Reporter: johannes.lists+bugs.kde....@tannenhof-imshausen.de
Target Milestone: ---
SUMMARY
I would like to directly query the database and let me show digiKam the
resulting images.
For example I would like to search for recently added images like
SELECT * FROM Images ORDER BY id DESC LIMIT 100
Or list all Images in a given directory with more then 5 recognized faces:
SELECT imageid, COUNT(*) as c, AlbumRoots.specificPath || Albums.relativePath
|| '/'|| Images.name AS "Pfad" FROM ImageTagProperties
LEFT JOIN Images ON Images.id = ImageTagProperties.imageid LEFT JOIN Albums ON
Albums.id = Images.album LEFT JOIN AlbumRoots On AlbumRoots.id =
Albums.albumRoot
WHERE album in ( select id from Albums
where relativePath like '/ExampleDirectory%')
GROUP BY
imageid
HAVING
c > 5
ORDER BY
c DESC
Do you see a way how to implement that or is there another way to archive my
request?
--
You are receiving this mail because:
You are watching all bug changes.
