Greetings
darktable version 2.6.2 on Ubuntu 18.04
I'm going through painful exercise of tagging large number of images.
I'm slowly opening one by one folder and tagging the image based on
event/place or whatever.
Is there anyway to find images not tagged in current collection - or
folder? Barring any other way available from darktable UI, I inspected
the database structure (library.db) and came up with following query.
With the full acknowledgment I'm opening darktable private database in
readonly mode, this should be enough to get me started. Any
thoughts/opinions?
Query basically getting file names in current film roll which don't have
entries in tag table for the tags that don't start with darktable
select filename from images i where i.film_id = (
select id from film_rolls f where f.folder like '%108___05'
)
and not exists (select 1 from tagged_images t, used_tags u where t.imgid
= i.id
and u.id = t.tagid and u.name not like 'darktable%'
)
Regards,
Niranjan
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to [email protected]
