Page 1 of 1

text value of the picklist field

Posted: Thu 14 Dec 2017 23:57
by bezpal
How do I get text value of the PickList column?
Here is part of my Enterprise.wsdl:

Code: Select all

<element name="RecordType" nillable="true" minOccurs="0" type="ens:RecordType"/>
<element name="RecordTypeId" nillable="true" minOccurs="0" type="tns:ID"/>
I can do

Code: Select all

Select RecordTypeId ...
and get 18-digit ID
but if I do

Code: Select all

Select RecordType ...
I get "Unknown column"

In Apex I can do

Code: Select all

RecordType.Name
Is there a way to build a query to extract RecordType text value?

Thanks!

Re: text value of the picklist field

Posted: Wed 20 Dec 2017 06:24
by Shalex
Please specify the name of Salesforce object (table) where you look for the RecordType column.

JIC: you can get the list of all columns available via interface of our provider using conn.GetSchema("Columns", new string[]{"TableName"});