Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Hyderabad Dynamics 365 User Group - Forum

Hyderabad Dynamics 365 User Group

(1) ShareShare
ReportReport
Posted on by 10

Hi , can anyone help me on universal fetch xml if you have an idea about it. Universal fetch xml is used in field service resource scheduling customization.

Link to universal fetch xml:

https://learn.microsoft.com/en-us/dynamics365/common-scheduler/developer/universal-fetchxml

Help to convert this normal fetchxml to universal fetchxml:

fetch top="50">
    <entity name="msdyn_resourcerequirement">
        <attribute name="msdyn_territory" />
        <filter>
            <condition attribute="msdyn_workorder" operator="eq" value="274b9ecf-8777-ed11-81ab-6045bd8c5107" uitype="msdyn_workorder" />
        </filter>
        <link-entity name="msdyn_resourceterritory" from="msdyn_territory" to="msdyn_territory" link-type="outer" alias="territory">
            <attribute name="msdyn_resource" />
            <link-entity name="bookableresource" from="bookableresourceid" to="msdyn_resource" link-type="inner" alias="brb">
                <attribute name="name" />
                <attribute name="resourcetype" />
                <attribute name="bookableresourceid" />
                <filter>
                    <condition attribute="resourcetype" operator="eq" value="8" />
                </filter>
                <link-entity name="bookableresourcegroup" from="parentresource" to="bookableresourceid" link-type="outer" alias="brbgroup">
                    <attribute name="name" />
                    <attribute name="fromdate" />
                    <attribute name="todate" />
                    <filter>
                        <condition attribute="statuscode" operator="eq" value="1" />
                    </filter>
                    <link-entity name="bookableresource" from="bookableresourceid" to="childresource" link-type="outer" alias="eng">
                        <attribute name="name" />
                    </link-entity>
                </link-entity>
            </link-entity>
        </link-entity>
    </entity>
</fetch>

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard > Hyderabad Dynamics 365 User Group

Featured topics

Product updates

Dynamics 365 release plans