Thank you! Exactly what I was looking for.
On Sun, 15 Apr 2018 12:02:08 +0200 Tobias Ellinghaus <m...@houz.org> wrote: >Am Samstag, 14. April 2018, 19:41:41 CEST schrieb >darkta...@911networks.com: >> DT 2.4.2 on manjaro >> >> I need to create a spreadsheet. >> >> Is there a way of exporting an image list/file list for: >> >> * tags >> * labels >> * ratings >> >> These settings don't have to be in the same list, I can merge them >> later. >> >> Is there a data diagram with the relationships? If there is one, I >> could do it with sqlitebrowser. > >The SQL would be something like this for tags: > >select folder || "/" || filename, used_tags.name from images inner >join film_rolls inner join tagged_images inner join used_tags where >images.film_id = film_rolls.id and images.id = tagged_images.imgid >and tagged_images.tagid = used_tags.id order by folder, filename; > > >For labels: > >select folder || "/" || filename, color from images inner join >film_rolls inner join color_labels where images.film_id = >film_rolls.id and images.id = color_labels.imgid order by folder, >filename, color; > > >Ratings are easier as they are in the same table as the filenames: > >select folder || "/" || filename, flags & 7 from images inner join >film_rolls where images.film_id = film_rolls.id order by folder, >filename; > > >Tobias -- sknahT vyS ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org