Re: List of files with a specific tag

Posted by Randy Wolf on
URL: http://digikam.185.s1.nabble.com/digiKam-users-List-of-files-with-a-specific-tag-tp4715803p4715813.html

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;