Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Need to Fetch record n...
Microsoft Dynamics CRM (Archived)

Need to Fetch record name from the Lookup field in fetch xml builder under Xrm tool box

(0) ShareShare
ReportReport
Posted on by jyotsna chakraborty 140

Hi All,

I am facing an isse while getting the record name from the lookup filed.

Currently i am writing a query in Fetch xml builder where i need a data from related Entity.

there is two entity Employe and Customer present in the system. Customer is a lookup field under Employee Entity.

whenever i try to write the query for getting data from Employee Entity it will return Customer Guid insted of name, for query creation i have used  fetch xml builder.

i know in C# its possible to get id and name from the lookup field. but i need to use this query on another Third party tool.

Can some one help me on this.

Regards,

Jyotsna

*This post is locked for comments

  • Inogic Profile Picture
    Inogic 24,094 on at
    RE: Need to Fetch record name from the Lookup field in fetch xml builder under Xrm tool box

    To retrieve the name from the lookup field, you need to add the link entity and then select the attribute (name) from that link entity.

     

    Please refer the below screenshot –

    fetch-xml.jpg

    Hope this helps. 

     

    Thanks!

  • Suggested answer
    NODAL Profile Picture
    NODAL 860 on at
    RE: Need to Fetch record name from the Lookup field in fetch xml builder under Xrm tool box

    Hi Jyitsna,

    FetchXML Builder have lot of personal options.

    Try checking Friendly Names or Press Cntrl + F

    pastedimage1567061348179v1.png

  • Suggested answer
    Vipin J Profile Picture
    Vipin J 1,583 on at
    RE: Need to Fetch record name from the Lookup field in fetch xml builder under Xrm tool box

    Check out this generic method to get details from a related entity.

    [View:http://vjcity.blogspot.com/2018/11/fetch-marketing-list-of-campaign-with-c.html:750:50]

  • rthompson Profile Picture
    rthompson 1,530 on at
    RE: Need to Fetch record name from the Lookup field in fetch xml builder under Xrm tool box

    Hi

    I hope you do not mind posting some of the code that you are using.  That would be very helpful to help you with your issue.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans