[Digikam-devel] [Bug 225869] New: Allow SQL search of images (which provides greater flexibility)

MichaƂ Borsuk michal.borsuk at gmail.com
Sun Feb 7 23:23:44 GMT 2010


https://bugs.kde.org/show_bug.cgi?id=225869

           Summary: Allow SQL search of images (which provides greater
                    flexibility)
           Product: digikam
           Version: unspecified
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: general
        AssignedTo: digikam-devel at kde.org
        ReportedBy: michal.borsuk at gmail.com


Version:           1.20?  (using KDE 4.3.2)
Compiler:          not applicable 
OS:                Linux
Installed from:    Ubuntu Packages

Hi developers, 

I would like to be able to perform SQL queries, or otherwise richer searches
than possible at the moment, because it is not possible to perform certain
searches at the moment (1.0.0). 

Possibly SQL on a multi-table database may be too hard for an average Joe, so
maybe a collection of drop-down lists to be combined in different sets, with
AND, OR and NOT between fields?


My specific problem: I do not know how to find images which haven't been
geotagged yet. SQL, however, solves this easily: 

SELECT id, name FROM Images WHERE NOT EXISTS (SELECT ImageId FROM
ImagePositions WHERE Images.ID = ImagePositions.ImageId)

PS Thanks a lot for your work so far. I admire your creation.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Digikam-devel mailing list