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.
/t5/lightroom-classic-ideas/p-search-by-original-filename-after-rename/idc-p/10552043#M23612Aug 12, 2019
Aug 12, 2019
Copy link to clipboard
Copied
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?
/t5/lightroom-classic-ideas/p-search-by-original-filename-after-rename/idc-p/12349943#M23616Aug 29, 2021
Aug 29, 2021
Copy link to clipboard
Copied
[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:
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.
/t5/lightroom-classic-ideas/p-search-by-original-filename-after-rename/idc-p/14354544#M23618Jan 14, 2024
Jan 14, 2024
Copy link to clipboard
Copied
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.
/t5/lightroom-classic-ideas/p-search-by-original-filename-after-rename/idc-p/14354657#M23619Jan 14, 2024
Jan 14, 2024
Copy link to clipboard
Copied
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"
/t5/lightroom-classic-ideas/p-search-by-original-filename-after-rename/idc-p/15117936#M23620Jan 28, 2025
Jan 28, 2025
Copy link to clipboard
Copied
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!