The current state of standardized queries is that it is enabled or disabled for an entire arcgis server instance. The standardized query functionality would be better suited at the service level.
I have 1 service out of 100 that needs to use sub queries in a where clause. A sub query violates the standardized query rules. In order to allow this one site to function properly, every other service on my server now has standardize queries disabled. This is not ideal or a best practice.
- Make standardize queries an option on the service not the server.
- much more configurable and awesome.
- Publish all services requiring standardized queries to a separate server.
- not a great option - expensive, more maintenance, yada yada
This is a duplicate of ArcGIS Server standardized SQL queries