I have a temporary table created to store record id's that I then retrieve using a query task with an inner select in the where clause. This has worked fine in services created in ArcGIS 10.1 and below, but does not seem to be working the same in 10.2+ version of ArcGIS services. I can use a list of IDs as a where clause:
MaterialTypeId in ('F2E55F1F-B493-422F-806A-CD8A82A5868E', 'EEF3E3DA-7B8A-447B-AE4C-B0CBDA21AED7')
but I can not use an inner select that generates a list of IDs as a where clause:
MaterialTypeId in (select top 2 Id from MaterialTypes)
Is there a way to accomplish this in the latest versions of the web service API? This has worked fine in versions prior to 10.2.