Thank you for the information.
i am using liquid template code in the Web template in Dynamics 365.
I am not sure how did you get the value="3" in your example. i am trying to get all the employee bookings that were saved with the value of reason for the entry (global option list value). I wouldn't know what would be the value if i need to specify as you have specified in your example.
i used fetchxml to query all employee booking data and try to display it as below.
{% for empBooking in employeeBookings.results.entities %}
<tr>
<td>{{ empBooking.fullname }}</td>
<td>{{ empBooking['fac.msft_name'] }}</td>
<td>{{ empBooking.new_reasonentry }} </td>
<td>{{ empBooking.new_reason }}</td>
</tr>
{% endfor %}
The image for my report can be found from this link. Here you will notice the reason for the entry column is empty. This is a mandatory field. so values are available for these records. Somehow it is not showing. Please advise me on how I can display the value.
https://higherlogicdownload.s3.amazonaws.com/D365UG/UploadedImages/dd80a9fb-fe50-4b71-a30f-623af0b46cbe/report.pngthis is the global option list fetch xml for the "reason for entry" dropdown
{% fetchxml reasonEntries %}
<fetch top="50" >
<entity name="stringmap" >
<attribute name="attributevalue" />
<attribute name="attributename" />
<attribute name="value" />
<attribute name="stringmapid" />
<filter type="and" >
<condition attribute="attributename" operator="eq" value="new_reasonentry" />
</filter>
</entity>
</fetch>
{% endfetchxml %}
Thank you
------------------------------
Siva Nama
AAFC
------------------------------
Original Message:
Sent: Feb 16, 2021 03:08 AM
From: Axel Girgensohn
Subject: fetchxml - retrieve entity data with a global option list
Hi @Siva Nama
I just tried on my contacts where blockedreason is a global option set. When using this FetchXML I get the results showing the option set value and the id. Use the Fetch XML tester in the XRM Toolbox to check your results. I assume you get the results but you would need to find the right way to show the name in your report instead of the ID. That would be a different question. In that case let me know in what program you build the report.
Fetch XML:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="contact"><attribute name="new_blockedreason" /><filter type="and"><condition attribute="new_blockedreason" operator="eq" value="3" /></filter></entity></fetch>
Result:
....
<result>
<new_blockedreason name="Deceased" formattedvalue="3">3</new_blockedreason>
<contactid>{............-.....-.....-.....-...............}</contactid>
</result>
...
------------------------------
Axel Girgensohn
Dynamics CRM Specialist
Aller Media AB
Original Message:
Sent: Feb 15, 2021 08:38 PM
From: Siva Nama
Subject: fetchxml - retrieve entity data with a global option list
Hi I have an employee booking entity with the "reason for entry" field.
For the Reason for Entry field i used global option set.
i used the following fetchxml to retrieve the data to create a report. all the fields bring the data except the "reason for entry" field. how i can retrieve the value of "reason for entry" field which comes from the global option set in my case. thank you, Siva
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="msft_employeebooking">
<attribute name="createdon" />
<attribute name="msft_employeeid" />
<attribute name="msft_facilityid" />
<attribute name="msft_bookingdate" />
<attribute name="new_mangerfullname" />
<attribute name="msft_employeebookingid" />
<attribute name="new_reasonentry" />
------------------------------
Siva Nama
AAFC
------------------------------