Executing query task using field alias instead of field name

[martinsutka]

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.

[AmayaMateos]

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

Thanks.

[TanuHoque]

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.