Library Filter or Smart Collection?

[clee01l]

I have ~3'' image files cataloged in a folder. They are imported from the camera card as the original DNG and its matching JPEG. These files have the same file name, differing only in type. Some of the DNGs have virtual copies. Some of the VCs have develop adjustments.

Is there a filter or Smart Collection that can be constructed to show only the VCs with adjustments AND the Master AND the JPEG master of the same name?

Filters/ Smart Collections that I have tried:

• 
  [li]I can get VCs with adjustment but no DNGs or JPEGs[/li]
  [li]I can get DNGs, JPEGs and VCs, but both with and without adjustments and DNGs with and without VCs[/li]

 

[johnbeardy]

As you've gathered, smart collections are rather underdeveloped - they're no Crystal Reports. Go for your first option - VCs with adjustments - and then you can jump to the original by clicking the turned up corner.

John

 

[clee01l]

[quote author=johnbeardy link=topic=7273.msg49562#msg49562 date=1248'74857]
As you've gathered, smart collections are rather underdeveloped - they're no Crystal Reports. Go for your first option - VCs with adjustments - and then you can jump to the original by clicking the turned up corner.

John
[/quote]Unfortunately, that does not bring in the companion JPEGs that in LR share nothing with the original DNG except the file name. It seems another case in LR where you "can't get there from here." All I need is a very basic subselect: SELECT * FROM table WHERE filename IN (SELECT filename from table WHERE copyname exists AND developAdjustment IS TRUE) Lightroom can be very frustrating at times.

 

[johnbeardy]

I have actually asked for a way to run SQL Selects via SDK access to the smart collections mechanism. Though I'm surprised Adobe didn't leap at the chance to silence my whining about the lack of "title is empty" or inability to target all fields in the database, I really don't expect to see it soon.

You could conceivably write a plug-in that loops through the catalogue and finds images meeting your criteria. catalog.find would help, and you'd probably mark the items in a way that a smart collection could detect.

John