How to filter one column with multiple values

[lefjucabro]

Hi,

I want to sync one table regarding multiple values for one field.

With the example below I want to sync ID field with values (2) and (3) :

                var SyncParameters = new SyncParameters
                {
                    { "ID", 3 },
                    { "ID", 2 }
                };
                ...
                var result = await agent.SynchronizeAsync(SyncScopeName, syncSetup, TmpSyncType, SyncParameters, progress);

I have an issue doing this: The parameter ID already exists in the parameter list.

Do I have to create as many SyncParameters as values that I want to filter and call SynchronizeAsync for each SyncParameters ?

Thanks for your comments

[Mimetis]

I think you should try to use AddCustomWhere

[lefjucabro]

Thank you, it works well.

I want to filter with AddJoin method, all my tables have a primary key named "ID". It seems the sync doesn't like this.
Do I need to rename the IDs to make them unique in my DB ?

[Mimetis]

should work, can you provide a quick sample to reproduce the error ?

[lefjucabro]

I tried this and it seems OK.
Is it the correct way to declare AddCustomWhere method for intervention.id and installation.id ? If I only declare {{{ID}}} i have some issues.
Thanks

        private void AddInterventionJoinFilter(ref SyncSetup _SyncSetup, string _TableName)
        {
            var SetupFilterTmp = new SetupFilter(_TableName);
            SetupFilterTmp.AddParameter("ID", "Intervention", false);

            SetupFilterTmp.AddJoin(Join.Left, "Intervention")
                               .On(_TableName, "INTERVENTION_ID", "Intervention", "ID");

            SetupFilterTmp.AddCustomWhere("{{{base}}}.{{{ID}}} IN (1,2) OR {{{side}}}.{{{sync_row_is_tombstone}}} = 1");

            _SyncSetup.Filters.Add(SetupFilterTmp);
        }
...

        /////////////////////////////////////////////////////////////////////////////
        var InterventionFilter = new SetupFilter("Intervention");
        InterventionFilter.AddParameter("ID", "Intervention", true);
        InterventionFilter.AddCustomWhere("{{{base}}}.{{{ID}}} IN (1,2) OR {{{side}}}.{{{sync_row_is_tombstone}}} = 1");
        syncSetup.Filters.Add(InterventionFilter);

        // Material linked to Intervention - INTERVENTION_ID on Material <--> ID on Intervention
        AddInterventionJoinFilter(ref syncSetup, "Material");


        // install
        var InstallationFilter = new SetupFilter("Installation");
        InstallationFilter.AddParameter("ID", "Installation");
        InstallationFilter.AddCustomWhere("{{{base}}}.{{{ID}}} IN (1) OR {{{side}}}.{{{sync_row_is_tombstone}}} = 1");
        syncSetup.Filters.Add(InstallationFilter);

[Mimetis]

Seems good to me !

[lefjucabro]

I want to filter the "control_input" table based on a list of IDs from the "Intervention" table.
Filtering the intermediate "Control" table is no problem thanks to the previously defined method.
However, I don't see how to filter "control_input".
Thank you for your advice.