Search This Blog

Loading...

Tuesday, December 14, 2010

Advanced Find Search: Where is this damn N:N relationship???

Did you ever have this feeling that something should behave in a way and you can’t figure out why this does not…?

I faced this feeling recently regarding the advanced find search. Here is the scenario: I created a N:N relationship between the account entity and a custom entity called Technology. As this relationship was just a “technical” one, I decided to hide left hand menu for this relationship. Below screenshots were taken for entity “test”.

NN1

“Ne pas afficher” means “Do not display”

When I then needed to perform an advanced find search on account related to a specific technology, I wasn’t able to select the N:N relationship in the list of relationships. I even thought that it was perhaps a normal behavior for N:N relationships (yeah, I know, that”s dumb, but I do not required N:N relationship for queries so often).

NN2

We can’t see “test” entity

Well, in fact, the solution was pretty simple, even if this is not mentioned anywhere: You have to keep the left hand menu of the relationship displayed to be able to use it in advanced find.

NN3 NN4

“Nom au pluriel” means “Plural name”, and we can now see “test” entity

1 comment:

Steve Noe said...

Nice! That's one that's been bugging me for a while. Added you blog to my Blogs we read list on MSCRMMASTER.COM