* [email protected] <[email protected]> [10-27-16 10:01]: > On Wed, 26 Oct 2016 16:25:06 -0700 > [email protected] wrote: > > >I know it's not a DT question but: > > > >select filename, version from images where version >=1; > > > >This gives me the list that I want but I can't seem to export the > >result, only full tables: File | Export |tables or database > > > >I can store the sql query as text but I can't store the result of > >the query. > > > >Any idea how to? > > In case people are also wondering on how to do it: > > sqlite3 -header -csv ~/config/darktable/library.db "select filename, version > from images where version >=1;" > out.csv > > will create the list of the images with duplicates and the number of > duplicates locate in out.csv of the current directory
~/config/darktable s/b ~/.config/darktable config is dotted :) -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
