Loading Label of choice columns via FetchXML

(0) Share

Report

Posted on by Lucas001

2,567 Super User 2026 Season 1

Hi all,

does anybody have a short trick on how to get the values of a choice column (global or column choice).

I want to get the label of the choice assigned to the record.

My choices column me_y, me_z are column choices the me_w is a global choice. Neither is working as hoped.

FetchXML for now would be:

<fetch top="50">
<entity name="me_x">
<attribute name="me_y" />
<attribute name="me_z" />
<attribute name="me_w" />
<attribute />
<attribute />
</entity>
</fetch>

Outcome is the following:

Any suggestion is appreciated.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Lucas001 2,567 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Seems to be easy.

Correct syntax is {{ item.me_y.label }}

Was this reply helpful? Yes No
GWham1 on at

Like
a
(0)

Report
Copy link

Link copied!
choice.label will work 😎

{% for result in tickets.results.entities %} {{ result.name }} {% for choice in result.choicefield %} {{ choice.label }} {{ choice.value }} {% endfor %} {% endfor %}

Was this reply helpful? Yes No
Suggested answer

shalinibh 2 on at

Like
a
(0)

Report
Copy link

Link copied!
you will need to join the table with stringmap table which is a system table that stores label-value mappings for all choice/option sets.

attributeName is the name of your choice field.

objecttypecode is the logical name of the entity (e.g., account, contact).

Below is the sample code for account table status code column labels
<fetch>
<entity name="account">
<attribute name="name" />
<link-entity name="stringmap" from="attributevalue" to="statuscode" link-type="inner" alias="sm">
<filter>
<condition attribute="attributeName" operator="eq" value="statuscode" />
<condition attribute="objecttypecode" operator="eq" value="account" />
<condition attribute="value" operator="eq" value="Approved" />
</filter>
</link-entity>
</entity>
</fetch>

Was this reply helpful? Yes No