Tags: beacause, crm, easily, fetch, guys, picklist, regards, retreive, retrieving, software, statement, text, value, values, xml

Retreive picklist text value from fetch xml

On Software » Crm

1,696 words with 0 Comments; publish: Mon, 19 May 2008 22:17:00 GMT; (40046.88, « »)

Hi guys,

I have a problem in regards to retrieving picklist text values from a fetch

xml statement.

Previously I was able to do this easily beacause when I retrieved xml from

an object which contains a picklist, the picklist contained an additional

attribute which had the name of the picklist field appended (with name or

code name) with the text value of the selected picklist.

if I had a picklist called CFPCarType and has id of 1 and a text value of

Ford and I select this picklist value on the record and save it, when I

retrieve the object which has this picklist field on it I get back the value

of 1.

What I used to be able to do on a previous Microsoft CRM system was to fetch

the xml and an attribute (called CFPCarTypeName or CFPCarTypeCodeName

existed with the text value of Ford populated, which made retrieving the

text value easy.

in fact any picklist I created had an additional attribute called picklist

name + codename which I could retrive when I used fetch xml which gave me

the selected text value of the picklist.

eg

<CFPCarType>1</CFPCarType><CFPCarTypeName>Ford</CFPCarTypeName>

or

<CFPCarType>1</CFPCarType><CFPCarTypeCodeName>Ford</CFPCarTypeCodeName>

For some reason I don't get back the picklist code name, which has the text

value.

For some reason I am unable to do this anymore on a new system I have setup.

This behavour is very strange, it seems as if I have dreamt this

functionality up!

Do you have any clues guys?

Thanks for your help

Lloyd

All Comments

Leave a comment...

  • 0 Comments