web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) "outer join"...

Microsoft Dynamics CRM (Archived)

"outer join" with advanced finds

(0) Share

Report

Report

Posted on by Community Member

Is there a way to create an advanced find to look compare 2 groups - if in group A but NOT in group B show me those?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Wouter Madou 3,392 on at

Like (0)

Report
Copy link

Link copied!

hi,

Outer join has been added to v9.

On the relationship you can now switch the option to 'does not contain data'.

in CRM4 however, you are out of luck.

I used to do it with the following method (crm2011+):

Create marketing list and add group A.
Evaluate your members and remove group B.

What's left is your 'in group A but not in group B'.

Regards,

Wouter

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Sorry you can not do outer join using fetchxml xml and advanced find in v 4.0.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

JS-09031509-0 3

#2

AS-17030037-0 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans