Hello everyone,

I have an Account table with a custom field with data type 'Picklist'.
What I want to do is, for each record in the account table I want the picklist value and also the label for that value.

Due to some limitations I can't execute the simple query ...
SELECT Custom_Field_1__c, toLabel(Custom_Field_1__c) FROM Account"

When I execute that query I get the error ...
INVALID_FIELD:
SELECT UCB_Specialty_1__c, toLabel(UCB_Specialty_1__c) FROM Account
^
ERROR at Row:1:Column:36
duplicate field selected: UCB_Specialty_1__c ].
caused by: AxisFault

If anyone knows a work around or a solution, I'd appreciate to hear about it.
Thank you.

Greetings,

Hamid

Hello everyone,

I have an Account table with a custom field with data type 'Picklist'.
What I want to do is, for each record in the account table I want the picklist value and also the label for that value.

Due to some limitations I can't execute the simple query ...
SELECT Custom_Field_1__c, toLabel(Custom_Field_1__c) FROM Account"

When I execute that query I get the error ...
INVALID_FIELD:
SELECT UCB_Specialty_1__c, toLabel(UCB_Specialty_1__c) FROM Account
^
ERROR at Row:1:Column:36
duplicate field selected: UCB_Specialty_1__c ].
caused by: AxisFault

If anyone knows a work around or a solution, I'd appreciate to hear about it.
Thank you.

Greetings,

Hamid

Hello everyone,

I have an Account table with a custom field with data type 'Picklist'.
What I want to do is, for each record in the account table I want the picklist value and also the label for that value.

Due to some limitations I can't execute the simple query ...
SELECT Custom_Field_1__c, toLabel(Custom_Field_1__c) FROM Account"

When I execute that query I get the error ...
INVALID_FIELD:
SELECT UCB_Specialty_1__c, toLabel(UCB_Specialty_1__c) FROM Account
^
ERROR at Row:1:Column:36
duplicate field selected: UCB_Specialty_1__c ].
caused by: AxisFault

If anyone knows a work around or a solution, I'd appreciate to hear about it.
Thank you.

Greetings,

Hamid