SQL to copy original filename to a searchable metadata field

[Rabbly]

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!

[areohbee]

See 'Original Filenames' preset in SQLiteroom plugin.

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

[areohbee]

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