Bug 495985

***
If you're not sure this is actually a bug, instead post about it at https://discuss.kde.org

If you're reporting a crash, attach a backtrace with debug symbols; see https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports

Please remove this comment after reading and before submitting - thanks!
***

SUMMARY
Feature request.  Not a bug

STEPS TO REPRODUCE
1. Not a bug
2. 
3. 

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
(available in the Info Center app, or by running `kinfo` in a terminal window)
Linux/KDE Plasma: 
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
One if the features I really like in Lightroom is the ability to look at counts of images using information from my image metadata.  It helps me understand my favorite bodies, lenses, focal lengths, shutter speed, f/stop, ISO and other camera settings.  It would be nice to have a screen where the user could select different metadata properties, and values or value ranges and then digiKam could populate a grid with the number of images matching the parameters.  For example, I'm considering a new wide-angle lens.  It would be nice to be able to see how many images I already have in my library with a focal length of less than 28mm.  What aperture did I use for most of the images? What ISO? Does it make sense to buy a faster wide-angle lens?  Would I use it enough?

I know I can make SQL queries directly against the SQLite or MariaDB databases, but most people don't have the tools or the knowledge to do so.

Here are a few of my favorite SQL queries.  If we could create a UI in digiKam so all users can see this information, I think it would be a great addition to the program.

Helps me understand the focal lengths and lenses I use most:
SELECT make,model,lens,focalLength,count(*) FROM ImageMetadata
WHERE make="SONY"
GROUP BY make,model,lens,focalLength
ORDER BY count(*) DESC;
 
Tells me my favorite lenses for my current body:
SELECT make,model,lens,focalLength,count(*) FROM ImageMetadata
WHERE make="SONY" AND model="ILCE-7RM3A"
GROUP BY lens
ORDER BY count(*) DESC;

Tells me my favorite ISO settings for a given focal length:
SELECT make,model,lens,sensitivity,focalLength,count(*) FROM ImageMetadata
WHERE make="SONY" AND model="ILCE-7RM3A"
GROUP BY sensitivity
ORDER BY count(*) DESC;