Inner Select in MapServer Where Clause

SteveBurdette — Tue, 07 Jul 2015 12:48:58 GMT

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

Re: Inner Select in MapServer Where Clause

SteveBurdette — Tue, 07 Jul 2015 16:30:58 GMT

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.

topic Re: Inner Select in MapServer Where Clause in Developers Questions

Inner Select in MapServer Where Clause

Re: Inner Select in MapServer Where Clause