Filter not working

[dorathoto]

Apparently the logic is simple and perfect, but I can't run the filter, it syncs but doesn't filter

I have several tables and I want to create a filter, where the tennantID column (FK) is equal to my GUID variable

ex:

var setup = new SyncSetup("dbo.Tennants", "dbo.Devices", "dbo.Audios", et cetera...)

setup.Tables["dbo.Tennants"].SyncDirection = SyncDirection.DownloadOnly;
setup.Tables["dbo.Devices"].SyncDirection = SyncDirection.DownloadOnly;
setup.Tables["dbo.Audios"].SyncDirection = SyncDirection.DownloadOnly;

Here the filters start:

var filterTennants = new SetupFilter("Tennants");
filterTennants.AddParameter("TennantId", DbType.Guid); 
filterTennants.AddWhere("TennantId", "Tennants", "TennantId");
setup.Filters.Add(filterTennants);


 var filterDevices = new SetupFilter("Devices");
 filterDevices .AddParameter("TennantId", DbType.Guid);
 filterDevices .AddWhere("TennantId", "Devices", "TennantId");
 setup.Filters.Add(filterDevices);

 var filterAudios = new SetupFilter("Audios");
 filterAudios.AddParameter("TennantId", DbType.Guid);
 filterAudios.AddWhere("TennantId", "Audios", "TennantId");
 setup.Filters.Add(filterAudios);

I've already tried sending the DbType.Guid type as the TableName ("TennantId", "Audios");

Here I define the created parameter called TennantID for my C# variable _myTennantId

var parameters = new SyncParameters
{
{ "TennantId", _myTennantId }
};

and at the end I execute:
var result = await agent.SynchronizeAsync(setup, parameters, progress);

Of course the code is much larger, error handling, etc., but I don't believe that this influences it.
It synchronizes all TennantIDs and not the one in my variable _myTennantId

[Mimetis]

Can you provide a quick repro sample, like a sql script that will create the database with some rows, and a bit of code to reproduce the error ?

[dorathoto]

Sure, I made a complete example
Create 2 MSSQL databases (Master and Local)
Enable Change Tracking
Create Seed by tennantId
Create Seed by Random Data.

Run the Sync Database by Dotmin creating the filter by tennant.
It does the sync but with all the data (Random and by tennant) I wanted the Local database to have only by TennantId == appSettings.jon

https://github.com/dorathoto/POC_DotMim.Sync.Sample

[Mimetis]

Thanks for the detailed sample, it's helping a lot, appreciate !

Can you try to remove the "dbo." in all your declaration, like replacing from this:

            var setup = new SyncSetup("dbo.Tennants", "dbo.Audios", "dbo.Led", "dbo.LedEffect");

            setup.Tables["dbo.Tennants"].SyncDirection = SyncDirection.DownloadOnly;
            setup.Tables["dbo.Audios"].SyncDirection = SyncDirection.DownloadOnly;
            setup.Tables["dbo.Led"].SyncDirection = SyncDirection.DownloadOnly;
            setup.Tables["dbo.LedEffect"].SyncDirection = SyncDirection.DownloadOnly;

to this:

            var setup = new SyncSetup("Tennants", "Audios", "Led", "LedEffect");

            setup.Tables["Tennants"].SyncDirection = SyncDirection.DownloadOnly;
            setup.Tables["Audios"].SyncDirection = SyncDirection.DownloadOnly;
            setup.Tables["Led"].SyncDirection = SyncDirection.DownloadOnly;
            setup.Tables["LedEffect"].SyncDirection = SyncDirection.DownloadOnly;

And make another test.
Let me know if it's working better

[Mimetis]

Is it working as expected now ?