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

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: [hidden email]
        ReportedBy: [hidden email]


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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
          Component|general                     |Database
            Version|unspecified                 |1.3.0




--- Comment #1 from Gilles Caulier <caulier gilles gmail com>  2010-02-08 07:39:49 ---
I not agree to add a way to customize sql queries in searches tool. It's not
user friendly.

you must to be precise on your demand and explain what's missing in current gui

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #2 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-08 18:26:58 ---
The set of search fields is not fixed for all times. I am happily accepting
suggestions what is missing. And you are right, there is nothing currently for
geolocation.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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





--- Comment #3 from Michał Borsuk <michal borsuk gmail com>  2010-02-08 19:40:16 ---
Created an attachment (id=40604)
 --> (http://bugs.kde.org/attachment.cgi?id=40604)
A concept of more advanced search

A concept of more advanced search. Here the AND operator is assumed, it would
be cool however to have OR also available (only OR and AND, not deeper logical
statements such as a AND (b OR C) - I'd myself have no idea how to implement
it)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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





--- Comment #4 from Michał Borsuk <michal borsuk gmail com>  2010-02-08 20:04:49 ---
So, what I really need at the moment is to be able to show all photos which
haven't been geotagged, so I thought of a search form on the lines of
OpenOffice Base, or Microsoft Access, that is not as difficult as SQL, but not
as (relatively) limiting as what is available now.

The present searches are great, but for example one cannot combine fuzzy sketch
AND timeline, or map search and something else (except tags, but I just found
it by chance). Or, I'd like to exclude AVI files from certain searches.

The answer is to create a search form that would allow to combine different
search parameters at once, and would not limit the number of them, and would
allow AND or OR between them.

Hope I made myself clear. And, by the way, I could write this.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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


Marcel Wiesweg <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #5 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-09 22:08:45 ---
I personally do not like this kind of search interface (*). That's why we have
a different one ;-) If there is really need for advanced advanced search, I
won't object, but I wont code it.
It does btw not fix the problem to integrate timeline, map or fuzzy searches
into a search - the backend needs to support that. I will be easy for map and
timeline and more complicated for fuzzy.

(*) I have no evidence or literature references. This would be interesting. My
main argument is this page: http://www.google.de/advanced_search?hl=en

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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





--- Comment #6 from Michał Borsuk <michal borsuk gmail com>  2010-02-09 22:34:24 ---
OK, I accept your argument. But how do I find pics which haven't been
geotagged?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #7 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-10 18:49:36 ---
The backend already has support to search for image in a radius around a given
coordinate, to search for images within one (spherical) rectangle defined by
two given coordinates, to search for altitude and for "nogps" which currently
means there is no latitude and no longitude entry.
It's only a matter of someone (probably me) adding a field to the UI. NoGPS is
the easiest among these.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Geolocation

--- Comment #8 from Gilles Caulier <[hidden email]> ---
SQL requests to ping database about image is out of goal of digiKam project =>
WONT FIX

It still missing an option to found no geolocated images in DB

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Allow SQL search of images  |Add option to found no
                   |(which provides greater     |geolocated image in
                   |flexibility)                |database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Add option to found no      |Add option to found no
                   |geolocated image in         |geolocated images in
                   |database                    |database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Mohamed]

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

Mohamed <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
      Latest Commit|                            |http://commits.kde.org/digi
                   |                            |kam/596693931ad3c03a2caacce
                   |                            |c3b3f21fe75e6f0ef
         Resolution|---                         |FIXED

--- Comment #9 from Mohamed <[hidden email]> ---
Git commit 596693931ad3c03a2caaccec3b3f21fe75e6f0ef by Mohamed Anwer.
Committed on 19/08/2014 at 15:54.
Pushed by mohamedanwer into branch 'master'.

Removing map selection after setting Non Geolocated items,
Polish UI,

M  +10   -9    utilities/gpssearch/gpssearchview.cpp

http://commits.kde.org/digikam/596693931ad3c03a2caaccec3b3f21fe75e6f0ef

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Mohamed]

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

Mohamed <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |4.3.0
                 CC|                            |mohammed.ahmed.anwer@gmail.
                   |                            |com

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel