I need to be able to query a mapservice that contains a number of different OBJECTIDs. In regular SQL I would say "(OBJECTID = 123) OR (OBJECTID =456). When I put this in my where clause of the Javascript API, I get an error that the where clause is an invalid parameter:
var query3 = new Query(); query3.returnGeometry = true; query3.where = "(OBJECTID=123) OR (OBJECTID=456)query3.outSpatialReference = { "wkid": 102100 };I need the geometry.
I have also tried where="OBJECTID in (123,456)" and I get the same error message. This is the result of a vendor limiting a query to 100 features unless a "resultOffset" that returns only IDs is used, so I need to first pull the 100 IDs and then I have to loop through to create another query that will pull the features that have those 100 IDs. It seems so simple, but I can't seem to do it! Please help!