topic Re: How to write the condition "Where in (...)" in ArcGIS API for Silverlight Questions

How to write the condition "Where in (...)"

AnatoliiTerentiev — Thu, 20 Mar 2014 12:53:17 GMT

Dear Gurus!
It needs to display on the map a set of records from x,y-table. I choose the desired records on a special form using different filters. I form an array of integer keys and pass them to the procedure with the next code:

public void OnShowQueryEvent(int[] codes)            
            QueryTask queryTask = new QueryTask("http://serverName:6080/arcgis/rest/services/situations/MapServer/0");
            queryTask.ExecuteCompleted += QueryTask_ExecuteCompleted;
            queryTask.Failed += QueryTask_Failed;

            Query query = new Query();
            query.ReturnGeometry = true;

            query.Where = "id_event IN (1684,1685,1688,1690)";

            queryTask.ExecuteAsync(query);

Here I have shown a predefined set of codes. And how to write a condition similar to the following

id_event in codes

Re: How to write the condition "Where in (...)"

AnatoliiTerentiev — Fri, 21 Mar 2014 04:16:46 GMT

Is it correct to form a similar expression from array?

Re: How to write the condition "Where in (...)"

DominiqueBroux — Fri, 21 Mar 2014 07:43:43 GMT

may be something like:

query.Where = "id_event IN (" + string.Join(",", codes) + ")";

Re: How to write the condition "Where in (...)"

AnatoliiTerentiev — Fri, 21 Mar 2014 09:18:00 GMT

Thank you very much!