Bug 515208

Summary: Advanced Search filter for specific EXIF Orientation values (Flipped/Rotated)
Product: [Applications] digikam Reporter: 1234destiny1234 <1234destiny1234>
Component: Searches-AdvancedAssignee: Digikam Developers <digikam-bugs-null>
Status: REPORTED ---    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version First Reported In: 8.8.0   
Target Milestone: ---   
Platform: Other   
OS: Other   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description 1234destiny1234 2026-01-28 15:20:46 UTC
I’m currently cleaning up a massive library and I’ve run into a tedious issue. I have hundreds of photos that are either rotated 90 degrees or flipped (wrong orientation),

I’m trying to isolate a specific set of images in my library where the Exif Orientation tag is set to anything other than "Normal" (e.g., flipped horizontally, rotated 180, etc.).

i have already used the advanced search option and tried to search using the exif orientation ( selected all except " normal" ) but the results are not correct.

I know digiKam can Auto-rotate/flip using Exif information, but before I apply any batch fixes, I want to search and review them first. 

Advanced Search: Is there a field in the digiKam Advanced Search Tool that lets you filter by the numeric Exif orientation value (like 2-8)?

Flipped Images: My main concern is images that are mirrored/flipped. Is there a way to filter for those specific tags specifically?
Comment 1 Maik Qualmann 2026-01-28 15:48:50 UTC
This search criterion already exists; look in the Photo Information section under Exif alignment.

Maik
Comment 2 1234destiny1234 2026-01-28 15:51:35 UTC
(In reply to Maik Qualmann from comment #1)
> This search criterion already exists; look in the Photo Information section
> under Exif alignment.
> 
> Maik

Yes i have tried this feature , but it does not show the flipped or wrongly orientated pictures that i have in the database.
Comment 3 Maik Qualmann 2026-01-28 15:52:48 UTC
I cannot detect any faulty alignment search in a short test.

Maik
Comment 4 Maik Qualmann 2026-01-28 16:04:27 UTC
The SQL debug output is definitely correct. Perhaps the orientations flag wasn't correctly captured during the initial scan for some reason. I would re-read all the metadata from the images.

Maik
Comment 5 1234destiny1234 2026-01-28 16:23:58 UTC
(In reply to Maik Qualmann from comment #4)
> The SQL debug output is definitely correct. Perhaps the orientations flag
> wasn't correctly captured during the initial scan for some reason. I would
> re-read all the metadata from the images.
> 
> Maik

Please can you advise the exact steps to search and filter all the photos which have images with correct Exif orientation tags ( top left ) but are just physically sideways on disk , since when i try to manually search and do  auto rotate using exif , its being rotated , although i am not able to search and filter these images using the advanced search option