Remove From My Forums

Check if a record has N:N relationship

Question
0

Sign in to vote
Given the guid of an entity and the name of the N:N relationship, I need to know how to check if it has any N:N relationships. I know how to retrieve all N:N relationships, but it gives an error for those guids that don't have any relationships. How to check if it has associated records?

Note that I have only one Guid and the relationship name. I need to know if it has any N:N relationship to any other record.

Thanks
- Edited by IamaNovice Sunday, September 29, 2013 8:20 PM
Sunday, September 29, 2013 8:16 PM

Answers

Hi,

Try this fetchxml query

<fetch>
  <entity name='systemuser'>
    <link-entity name='teammembership' from='systemuserid' to='systemuserid' visible='false' intersect='true'>
      <link-entity name='team' from='teamid' to='teamid' alias='ai'>
        <filter type='and'>
          <condition attribute='name' operator='eq' value='{guid here}' />
        </filter>
      </link-entity>
    </link-entity>
  </entity>
</fetch>

Kids don't try this at home!

Marked as answer by IamaNovice Thursday, October 10, 2013 4:41 PM

Wednesday, October 2, 2013 3:55 AM

Answered by:

Check if a record has N:N relationship

Question

Answers