topic Executing query task using field alias instead of field name in ArcGIS REST APIs and Services Questions

Executing query task using field alias instead of field name

martinsutka — Thu, 30 Jun 2011 08:33:30 GMT

Hi,

I am not able to find the solution on how to execute query task using field alias instead of field name in the where condition.

Lets say I have a field defined like this:

SOME_FIELD (Type: esriFieldTypeString, Alias: SMF, Length: 15 )

using the where condition " SOME_FIELD = '000000000001943' " will get the result,
but using the where condition " SMF = '000000000001943' " will get the message "Unable to perform query."

Thanks.

Re: Executing query task using field alias instead of field name

AmayaMateos — Thu, 16 May 2013 07:39:00 GMT

Hello!!! Could you do it? I want do it too.

Thanks.

Re: Executing query task using field alias instead of field name

TanuHoque — Tue, 28 May 2013 16:49:30 GMT

you must use FieldName with the query. FieldAliases are not supported.
Field-aliases live either in the mxd or at the GDB stack, the underlying database is not aware of this, as a result it fails.