Unable to pass mulitple filter values while sycing


I want to pass multiple values to a filtering field while syncing. Its not allowing me to specify multiple values for a Scope Parameter. How can I achieve this?

Work scenario:
I have two tables named "Country" and "City". City is having a foreign key relation ship with Country by country ID. I want to sync all cities from city table which are having country id as 1 or 2 or 3. So i need to pass all these 3 values in the Scope Parameter for filtering. Right now am able to set only one filter value.
How can I resolve this issue?
Expecting a quick reply.

Closed May 22, 2014 at 12:30 PM by Mimetis


Mimetis wrote Apr 30, 2014 at 9:24 AM

You can't pass multiple values to parameters.

At least, make a server table within a unique key linked to your list of values
This table is not synced (you can, but it's not mandatory)

ParameterKey  |  Value
1000           | 1
1000           | 2
1000           | 3
Then you pass your unique parameter in your code
this.SyncContext.AddScopeParameters("ParameterId", 1000);

AnsaryAns21 wrote Apr 30, 2014 at 9:35 AM

Dear Sébastien,

Thanks for the update. :-)


wrote May 22, 2014 at 12:30 PM