Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

P: Search by Original Filename after rename

Explorer ,
Aug 12, 2019 Aug 12, 2019

Is there a way to search for images in LR Classic by original file name?

 

Thank you!

 

Message was edited by: Akash Sharma

Idea No status
TOPICS
macOS , Windows
1.7K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
12 Comments
New Here ,
Apr 02, 2014 Apr 02, 2014

Hi,

I made a large number of changes to the names in my library, and would like to do a search based on the original filename to find images. I found a plugin (AnyFilter - http://www.johnrellis.com/) which allows me to search a number of different fields, but Original Filename is not one of them.

I was hoping someone could help me out with the SQL required to copy the Original Filename within the database directly to some field that would be searchable? I understand how to open and execute SQL against the lightroom database, I'm just not familiar enough with the lightroom db schema to write this myself.

Thanks in advance!

Translate
Report
LEGEND ,
Apr 02, 2014 Apr 02, 2014

See 'Original Filenames' preset in SQLiteroom plugin.

http://www.robcole.com/Rob/ProductsAndServices/SQLiteroomLrPlugin

Translate
Report
LEGEND ,
Nov 14, 2014 Nov 14, 2014

Cheap n' dirty way to get original filename:

Make a filenaming preset which uses original filename (only).

local originalFilenameBase = photo:getNameViaPreset( id )

Note: you can't get the extension that way, but still..

R

Translate
Report
Aug 12, 2019 Aug 12, 2019

Hi DRF1000,

Once the image is renamed in Lightroom, I don't think you can search by the original filename. However, It seems like a great idea, could you share this as a feature request here?

Lightroom Classic | Photoshop Family Customer Community

This forum is monitored by our developers and they might look into it for future updates\

Regards,

Akash

Translate
Report
Community Expert ,
Aug 12, 2019 Aug 12, 2019

Have you tried ‘Any searchable field’ in the filter bar? If that doesn’t work, then apparently that field is not searchable.

-- Johan W. Elzenga
Translate
Report
New Here ,
Aug 29, 2021 Aug 29, 2021

I cannot believe i can't locate an image by it's file name in a software designed to catalog images. 

Translate
Report
LEGEND ,
Aug 29, 2021 Aug 29, 2021
quote

I cannot believe i can't locate an image by it's file name in a software designed to catalog images. 


By @mileece

 

Of course Lightroom Classic can find files by file name.

Translate
Report
LEGEND ,
Aug 29, 2021 Aug 29, 2021

[This post contains formatting and embedded images that don't appear in email. View the post in your Web browser.]

 

"I cannot believe i can't locate an image by it's file name in a software designed to catalog images."

 

To search by file name, use the Text Filename criterion of the Library Filter bar and smart collections:

 

johnrellis_0-1630256908074.png

 

To search the Preserved File Name field (which stores the original file name before a photo was renamed in LR), you'll have to use the Any Filter plugin.

 

Translate
Report
New Here ,
Jan 13, 2024 Jan 13, 2024

Hi,

Is it possible to search by part of a file name and save that search?

Harry

Translate
Report
Community Expert ,
Jan 14, 2024 Jan 14, 2024

Of course. Change 'Starts with' as shown in John's screenshot to 'contains'. You can save a search by creating a smart collection. If you just want to save the result of a particular search, then add the images to a new normal collection.

 

-- Johan W. Elzenga
Translate
Report
LEGEND ,
Jan 14, 2024 Jan 14, 2024

You can perform the search, and then in the Filter Bar save the search by clicking where it says "Custom Filter" and then selecting "Save Current Settings as New Filter"

Translate
Report
New Here ,
Jan 28, 2025 Jan 28, 2025
LATEST

I have concluded that the only way to find a photo with a certain name in the Original Filename field is to use the "Any Filter" plug-in by John Ellis.

 

What is Adobe thinking by not enabling searches on Original Filename with the Library Filter: Text> Any Searchable Field? This omission is most maddening!

 

Tim

LrC 14.1.1

macOS Sonoma

Translate
Report