1

Closed

Unable to pass mulitple filter values while sycing

description

Hi,
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?
Image
Expecting a quick reply.

-Regards,
Ansary.R
Closed May 22 at 12:30 PM by Mimetis

comments

Mimetis wrote Apr 30 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)

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

AnsaryAns21 wrote Apr 30 at 9:35 AM

Dear Sébastien,

Thanks for the update. :-)

-Regards,
Ansary.R