limit for query where clause

Discussion created by ncarter77 on May 1, 2013
Latest reply on May 6, 2013 by ncarter77
I have found that there is a limit to the count of items in the WHERE param of a query operation against a mapping and/or feature service.  This is not the returned limit param but the WHERE param of the query itself before it will generate a response.  The limit i have found is 1,000 items.  It does not matter if they are string or integer items or how long the items are; ie not a character limit but a "word" limit. I have tested increasing the Maximum Number Of Records to Return by Server param to a couple of thousand but the query operation returns a code 400 - "unable to complete query".

All postings and documentation I can find say nothing about a WHERE item limit.

I am using ArcGIS Server v10.04.

Please advise,

Nat Carter
Montana DEQ