Tip #339: N:N relationships and Advanced Find

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.

5 thoughts on “Tip #339: N:N relationships and Advanced Find

  1. Thue says:

    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.

    • Joel Lindstrom says:

      Thue,
      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.

  2. anju says:

    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?

  3. Andy says:

    Hello,

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *