Good morning everyone,
I am trying to develop an application using ArcGIS JavaScript API, one of the function is draw a box on map and do the spatial query, then only the features inside or intersect with the box are display and all the rest feature should disappear.
currently I use spatial query from box and get all the feature OIDs and then add definition query like,
OBJECTID in (123, 124, 1245, .....2111)
However since our map service point to Oracle database, oracle have limitation on number of values in the list, currently is 1000, so if there are more than 1000 values in the list, then definition query won't work, and the entire layer disappear.
