Lightroom: Filter and smart collection criteria Title Starts With and Title Ends With don't work

  • 2
  • Question
  • Updated 3 months ago
Sure. 
Title = "Deerpark Court Tomb with Lough Gill in background"
Filter = text Title Ends With "deerpark"
displays the photo even though title does not end with "deerpark"
same photo
Filter = text Title Starts With "background"
displays the photo even though title does not start with "background"

Note: This conversation was created from a reply on: Lightroom: Text filtering problems with "Starts With".
Photo of Calvin Hilton

Calvin Hilton

  • 18 Posts
  • 0 Reply Likes

Posted 3 months ago

  • 2
Photo of John R. Ellis

John R. Ellis, Champion

  • 5123 Posts
  • 1452 Reply Likes
Title Starts With and Title Ends With are matching against individual words rather than the entire Title field. This bug is similar to the one with Filename, which was fixed quite a while ago.

I tested Caption, Keywords, and Copy Name, and they worked correctly.
Photo of Calvin Hilton

Calvin Hilton

  • 18 Posts
  • 0 Reply Likes
Granted I don't know anything about LR internals but if I was given the assignment of coding these filters I'd create a common routine that would take three input parameters: field name (e.g. Title), operator (e.g. Contains) and string.  If the routine worked for filename it would work for title.  Maybe someone who's familiar can shed some light.

Regardless, I would have thought that Adobe would have checked the other options while they were fixing it for Filename.
Photo of John R. Ellis

John R. Ellis, Champion

  • 5123 Posts
  • 1452 Reply Likes
I believe complications arise from how LR implements fast full-text search, and the bugs with Title and filenames are fall-out from those complications.  There are (at least) three categories of searchable metadata fields:

- The field is individually searchable by name (e.g. Caption).

- The field is individually searchable by name and supports exact match via "is" (e.g. Creator).

- The field is not individually searchable by name but is via Any Searchable Metadata, Searchable EXIF, or Searchable IPTC (e.g. User Comment).

Only a few of the text fields support exact match ("is"), a big design mistake (e.g. no exact match of keywords). I believe this was a consequence of the full-text indexing component Adobe used in conjunction with the SQLite database used for the catalog. It appears that the full-text indexing (or at least the way Adobe used it) doesn't support exact match, and LR has to do something special to support it. It may be the developers thought that supporting exact match on every field would cost too much in performance, but that's just speculation.

Regardless, the bug with Title is likely fallout from these complications.