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?
Hi, I'm not favourable to open search tool to direct SQL queries. This can be dangerous as user can break database structure by this way. Note: with Python, you can to be connected to the database with a stand alone tool and interrogate the database outside digiKam, to list files. Best Gilles Caulier
With python it's possible to query the database and show the resulting files in digiKam? Can you point me to further information about it, please? Thanks a lot! I understand that direct SQL queries can be dangerous if UPDATE and DELETE are supported. I was wondering if there might be a way to only allow SELECT queries.
Look this repository on Github for example : https://github.com/looran/digikuery Gilles Caulier
Thanks for your response but I can't figure out how to use that to let digKam display the resulting images of an external query.
(In reply to caulier.gilles from comment #1) > I'm not favourable to open search tool to direct SQL queries. This can be > dangerous as user can break database structure by this way. What about giving users the opportunity to only write the WHERE-part of the SQL directly in digiKam? This would allow a lot more flexibility which seems to be not that easy to implement in the Advanced Search dialog.
*** Bug 473731 has been marked as a duplicate of this bug. ***
(In reply to Johannes from comment #5) > (In reply to caulier.gilles from comment #1) > > > I'm not favourable to open search tool to direct SQL queries. This can be > > dangerous as user can break database structure by this way. > > > What about giving users the opportunity to only write the WHERE-part of the > SQL directly in digiKam? > > This would allow a lot more flexibility which seems to be not that easy to > implement in the Advanced Search dialog. I am also interested, due to the current unknown behaviour when combining OR and AND search groups... I'd like to build query with parenthesis and prioritised combination of AND / OR conditions.