Suggested Wed, 06 Jul 2011 06:00:00 GMT by Peter HörnellPlanned Short Term
Category: Client-Side Programming

A very common request from customers is to find records WITHOUT a certain related record. Today I need to make a custom report for that. I think it would be great to be able to create views etc based on NOT IN statements in an advanced find. That could easily be used for customers to set up even more dynamics marketing lists too.

Status Details

Thank you for your feedback. This is a great suggestion! We will consider this in our roadmap.



Neeraj Nandwana

PM, Microsoft 

Comments (40)
  • Hi Mike Carter- This functionality is NOT yet implemented. Can you change the status of the case? Tks
  • Agreed - still want this in the Advanced Find. Why is this marked as resolved?
  • I also don't consider this resolved; the request was for it to be exposed in advanced find and it is not.
  • @Simon, I totally agree with you that this is not really to be considered "fixed", but it's a first step for us partners to be able to help the customers finding posts that doesn't have a relation to a certain 1:N entity. It's a start, but we really need a way to achieve this though the UI so customers can create these kinds of views/search queries themselves.
  • Except it's not really "fixed" for most people is it? They want to be able to do this with the Advanced Find UI - they don't want to have to use the SDK to create (or modify) the views.
  • Hi GebRom, Please refer to http://www.powerobjects.com/blog/2013/11/07/perform-left-join-fetchxml-display-results-crm-2013/ A good functional guide for performing Left Joins (i.e. NOT IN queries). HTH
  • We tried it on our CRM Fall 13 Online as well as on our Testing CRM 2013 on premise Environments and could not find this feature. Could you indicate where to find it? Thank you DI(FH) Roman Gebesmair CRM Consultant
  • Thank you for your suggestion. We have delivered this functionality in the Dynamics CRM 2013 release. Mike Carter This posting is provided "as is" with no warranties, and confers no rights.
  • Seems like this feature made it to CRM 2013, happy times! :)
  • I agree, this does seem like a basic feature that just isn't there! A 2 year old suggestion with far more votes than anything else should be in there by now. There are other examples of "workarounds" - Contacts: No Orders in last 6 months, Contacts: No campaign activities in last 3 months etc, so it can be done. We just need it configurable! Anyone know if it's coming in Orion?