[digiKam-users] List of files with a specific tag

Randy Wolf randy.wolf at gmail.com
Sat Apr 10 13:28:12 BST 2021


Not sure if helpful to you, but you can easily do this on the backend db if
you know sql.

Care should be taken, you can trash the db.

If you are using the SQLite db with Digikam you can download the sqlite3
cli and run sql commands and export to txt file. Or use a GUI tool.

The three tables at play are: Tags, Images, and ImageTags

You can use a select to lookup the id in Tags:
select * from tags;

Then another select to get a list of files with that tagid:
select images.name from images, imagetags where imagetags.tagid=100 and
images.id=imagetags.imageid;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20210410/e77c03d8/attachment.htm>


More information about the Digikam-users mailing list