News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Multiple two entities ...

Microsoft Dynamics CRM (Archived)

Multiple two entities with specific criteria

(0) Share

Report

Report

Posted on by Stelios Anestis

I want to create a js file to take as result a grid of fields from two different entities. Here, is the problem:

I have a custom entity with the name New and the fields name1,name2,name3 with 400 records. The name1 has 400 different values.

I have another custom entity with the name Old and the fields last1,last2,last3 with 5000 records.

I want as result to take all the records from Old entity where last1 = "XXXX" and last2=name2.

The final result will have the fields name1,name2,name3,last1,last2,last3.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Stelios Anestis on at

Like (0)

Report

RE: Multiple two entities with specific criteria

Thank you very much

i will try the next days
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple two entities with specific criteria

Hi Stelios,

proceed as follows:

1) Build a fetch xml joining two entities data, this page show you how to do:

https://us.hitachi-solutions.com/blog/understanding-fetchxml-outer-joins/

2) Call you fetch from on load through web api, using the generated fetch xml

Please let me know if you solve.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,309 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans