Formula category for files having a specific buddy file - how?

[bekesizl]

Hi,

As a new user I would like IMatch to support me working with my RAW files and more easily keeping track of what I have edited already.
I use DxO Photolab as RAW editor and have added buddy relations to the .cr3.dop files, and a versioning relation between my original cr3+jpg pair and a DxO exported _DxO.jpg.

I also successfully set up a formula category listing all files having "DxO" in the name listing all exported files.

I can set up a manual category to put the files in there that I want to edit.

Now I would like to have an automatically updating category for every CR3 file in the database that has a .CR3.dop buddy file. That would be a list of all the files I have edited.

Then I would like to have two further automatic categories:
-Photos to be edited -> "Manual category" minus "has buddy file"
-Photos not exported -> "has buddy file" minus "exported files"

Reading the manual and checking the program I haven't found a way to formulate the "has buddy file".

The set operations I guess would be doable via the Category @Builder https://www.photools.com/help/imatch/#cat_builder.htm.

Or am I looking for something not possible?

Zoltán

[Mario]

Example: the variable

{File.BuddyFiles|hasvalue:1;0}

returns 1 if the file has a buddy file, else 0.

[bekesizl]

Thank you!
Following expression gets the expected results in VarToy.

{File.BuddyFiles|contains:.dop,dxo_edited,not_edited}

But how do I formulate a FormulaCategory from this expression?

The neares comes this
"@FileRegExp[{File.BuddyFiles|contains:.dop,dxo_edited,not_edited}]"
but this only works with the filename, not with the values of variable, so my example gives nothing as result.

[Mario]

You cannot use variables in category formulas. What makes you think that?
You can use variables in data-driven categories, if you really have to. It works, but can be very slow and should be used only to solve very specific problems.
See Data-driven Categories

[bekesizl]

I was rather thinking of a formula category for this case and the title shows it also.
It is not that easy to understand all the possibilities.

But now I managed to set up a data driven category with the expression in my former post and this part works.

The boolean operation of the photos "Not yet exported" doesn't give me the expected results and I guess that it will stay this way with the versioning rules.
I will have to think this over one more time.

Most probably this very simple formula which shows every exported file is not correct for the boolean operation as this delivers only the jpgs and the other delivers the Master versions.
"@FileRegExp[DxO]"

Maybe I will have to make another formula for buddy files containing DxO in the name and so I will be able to see, if they were already exported.