ArcGIS Server 10.2 - Subqueries In Map Services Don't Work Anymore

[RafaelFerraro]

In a 10.1 map service, I successfully used many subqueries on my map services.. An example where clause would be: 

AIRCRAFT_ID IN (SELECT AIRCRAFT_ID FROM COUNTRY_AIRCRAFT WHERE COUNTRY_ID = 5)

All data is stored in a file geodatabase.  After the upgrade to 10.2, this no longer works.  I didn't change the code, or the gdb.  Worked flawlessly in 10.1 for many moons.

Has anyone experienced anything similar?

[IsmaelChivite]

Hi,

please have a look at this help topic: http://resources.arcgis.com/en/help/main/10.2/index.html#/About_standardized_queries/015400000641000...
ArcGIS 10.2 for Server has a new setting that helps prevent SQL Injection Attacks. This new setting may be blocking your subqueries. The help topic describes what particular SQL statements are being blocked, and how to disable the SQL filters in 10.2 in case that you may want to do that.

Ismael Chivite