2 Replies Latest reply on Nov 14, 2014 3:07 AM by areohbee

    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!