That was well worth knowing!
A lua script that output selected data to a text file would be very useful.

David

On 04/15/2018 03:02 AM, Tobias Ellinghaus 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
> 
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

Reply via email to