How to know child records which are not part of the parent record

(0) Share

Report

Posted on by Community Member

Hi,

Using advanced find how do I know which are the leads that are not associated to the marketing Lists? If I select Leads under advanced find and select marketing lists under "related" and select marketing lists ->does not contain data, CRM does not render any result. Any suggestions?

Regards

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

RE: How to know child records which are not part of the parent record

Hi,

For this type of queries you need to write left outer join query, now CRM support that but still out of the box advanced find can't do, but you could use http://fxb.xrmtoolbox.com/ to write this query, or you can build report by writing this query.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: How to know child records which are not part of the parent record

You can install CRM Intelligent Query to perform this type of Advanced Find. www.cobalt.net/cobaltintelligentquery

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

RE: How to know child records which are not part of the parent record

If its a onetime than i would use the bookmark tip posted by raj to get this list

dreamingincrm.com/.../bookmarklet-advanced-find-outer-join-a-k-a-not-in-condition

Was this reply helpful? Yes No