Inner Select in MapServer Where Clause

2704
1
Jump to solution
07-07-2015 05:48 AM
SteveBurdette
Occasional Contributor

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.

Thanks,

Steve

0 Kudos
1 Solution

Accepted Solutions
SteveBurdette
Occasional Contributor

I set the System Property standardizedQueries to false using the Admin service (http://myserver.mydomain:6080/arcgis/admin) and that solved the inability to use inner selects in queries. 

View solution in original post

1 Reply
SteveBurdette
Occasional Contributor

I set the System Property standardizedQueries to false using the Admin service (http://myserver.mydomain:6080/arcgis/admin) and that solved the inability to use inner selects in queries. 

View solution in original post