So you create a many-to-many relationship and add data to it, then you want to run an Advanced Find filtered on that relationship. But when you run the advanced find, you don’t get any results. What’s up?
The reason you don’t get anything back is because you have the relationship set to not display in the navigation area. Update your relationship to display on both sides of the relationship, and you will be able to filter advanced find off of the relationship and return results.
Well, how about if you want to search for +1 values that can exist in more than one of the entities data?
E.g. Account has a n-n relations to a custom entity called Industry. I now want to search for accounts that has 2 different values (a and-statement) from the custom entity.
You can filter advanced find based on multiple N:N relationships, If you are doing an “And” query–get me everything where this AND that are correct. With advanced find you can’t do related entity “or” filters, or “not in” filters. You can if you do Fetch XML surgery, but not through OOTB advanced find.
suppose I do Fetch XML surgery using XrmtoolBox will I be able to search for +1 values that can exist in more than one of the entities data using a CUSTOM VIEW?
Yes you can but it is not for the faint of heart. Good luck!
I have the following scenario:
Entity contact, has two relationships many to many, with entities: economic sector and languages.
The business user (end user) wants to search for contacts with economic sectors A and B and languages X and Z.
Please, how can I customize this requirement?
Thank you very much for your help.