Microsoft Dynamics CRM (Archived)

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

(0) Share

Report

Posted on by jyotsna chakraborty

144

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

I have the same question (0)

All responses (4)

Answers (0)

rthompson 1,532 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Vipin J 1,603 on at

Like (0)

Report
Copy link

Link copied!

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]

Was this reply helpful? Yes No
Suggested answer

NODAL 860 on at

Like (0)

Report
Copy link

Link copied!

Hi Jyitsna,

FetchXML Builder have lot of personal options.

Try checking Friendly Names or Press Cntrl + F

Was this reply helpful? Yes No
Inogic 743 on at

Like (0)

Report
Copy link

Link copied!

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 –

Hope this helps.

Thanks!

Was this reply helpful? Yes No