Multiple alternative filters possible

[truthz03]

Hi,

I have a scenario where I need a filter to my table (FileData) but the UserId is only available inside one of its parent tables.
I know that I can use filter.AddJoin to get up to my parent table but what if the are multiple ways to a parent?

In my example I need to check if ObjectsecurityAttachment or FormAttachment contains the right FileId and then use the UserId from the Objectsecurity or Form table.

Is this possible in any way with the latest version of Dotmim.Sync (1.3)?

[Mimetis]

using CustomWhere ?

[truthz03]

Is there an example how to use it?
Do I have to use AddJoin together with CushomWhere?

[Mimetis]

No there is no AddCustomJoin

Usually, in that case, I think that AddCustomWhere should contains a Where clause that have a subquery in it
like

And UserId in (Select ...... JOIN .... JOIN ... Where ....)

[truthz03]

I get it working.

If anybody else is interessted I do the following things:

1. Use filter.AddJoin like before for all parent tables
2. Use filter.AddParameter only once per column name (in my case UserId is used in all top level tables)
3. Use filter.AddCustomWhere only one with the following parameter

"([Objectsecurity].[UserId] = @UserId OR [Form].[UserId] = @UserId)"

[Mimetis]

Don't forget to handle deleted rows : https://dotmimsync.readthedocs.io/Filters.html#how-to-get-deleted-rows-in-your-where-clause

[truthz03]

Ok. Then I miss something.
This seems to be the problem here