Bug 225869

Summary: Add option to found no geolocated images in database
Product: [Applications] digikam Reporter: Michał Borsuk <michal.borsuk>
Component: Searches-MapAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: wishlist CC: caulier.gilles, marcel.wiesweg, mohammed.ahmed.anwer
Priority: NOR    
Version: 1.3.0   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In: 4.3.0
Sentry Crash Report:
Attachments: A concept of more advanced search

Description Michał Borsuk 2010-02-08 00:23:42 UTC
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.
Comment 1 caulier.gilles 2010-02-08 07:39:49 UTC
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
Comment 2 Marcel Wiesweg 2010-02-08 18:26:58 UTC
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.
Comment 3 Michał Borsuk 2010-02-08 19:40:16 UTC
Created attachment 40604 [details]
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)
Comment 4 Michał Borsuk 2010-02-08 20:04:49 UTC
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.
Comment 5 Marcel Wiesweg 2010-02-09 22:08:45 UTC
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
Comment 6 Michał Borsuk 2010-02-09 22:34:24 UTC
OK, I accept your argument. But how do I find pics which haven't been geotagged?
Comment 7 Marcel Wiesweg 2010-02-10 18:49:36 UTC
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.
Comment 8 caulier.gilles 2014-08-07 06:03:35 UTC
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
Comment 9 Mohamed 2014-08-19 15:55:16 UTC
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