Select to view content in your preferred language

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

665
3
03-20-2014 05:53 AM
AnatoliiTerentiev
Deactivated User
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
?
0 Kudos
3 Replies
AnatoliiTerentiev
Deactivated User
Is it correct to form  a similar  expression from array?
0 Kudos
DominiqueBroux
Esri Frequent Contributor
may be something like:

query.Where = "id_event IN (" + string.Join(",", codes) + ")";
0 Kudos
AnatoliiTerentiev
Deactivated User
Thank you very much!
0 Kudos