westchamp24

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

Discussion created by westchamp24 on Aug 26, 2013
Latest reply on Aug 26, 2013 by ichivite-esristaff
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?

Outcomes