topic Error with Max on Query in Developers Questions

Error with Max on Query

EvelynHernandez — Tue, 24 Mar 2015 13:35:43 GMT

Hello everyone,

I was making a query to a REST service in the v 10.2, with a MAX value, it was working perfectly with the following sentence:

CENTRAL_ID=(SELECT MAX(CENTRAL_ID) FROM CENTRAL_PMGD)

My Rest Srv is containing the following fields:

Fields:

OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
EMPRESA_ID ( type: esriFieldTypeInteger , alias: PERIODO_STAR , editable: true , nullable: true )
PERIODO_STAR ( type: esriFieldTypeString , alias: PERIODO_STAR , editable: true , nullable: true , length: 6 )
CENTRAL_ID ( type: esriFieldTypeInteger , alias: CENTRAL_ID , editable: true , nullable: true )

When i try to do the same query in the v 10.3 i got the following error ...

¿How can i do it?

Thanks for ur answer

Re: Error with Max on Query

AhmedEl-Sisi — Tue, 24 Mar 2015 14:57:55 GMT

My first thought is to check whether Standardized Queries is enabled or not.
If enabled the server will not allow the database-specific functions.

Re: Error with Max on Query

EvelynHernandez — Tue, 24 Mar 2015 15:35:30 GMT

The thing is, yesterday we updated the srv to the v 10.3. Idk if doing the change that u say it will affect too much to the services or the entire service.

Theres no documentation talking about that in the v10.3 .. just the link that u showed me its talking about 10.2

Maybe the way (sintaxis) to do it is now kinda different.

Anyone has experienced this trouble?

Re: Error with Max on Query

AhmedEl-Sisi — Tue, 24 Mar 2015 16:01:06 GMT

Check "Use Standardized Queries" for your layer through the rest map service directory first.
It should be like "Use Standardized Queries: true"

Also check documentation for Standardized Queries from 10.3 help.

Re: Error with Max on Query

EvelynHernandez — Tue, 24 Mar 2015 16:51:52 GMT

I will try it, thanks for ur answer