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

Reply via email to