Return ActivityParty PartyId related entity using FetchXML

(0) Share

Report

Posted on by JasonVC

I'm working on an Data Vault project and need to bring in the ActivityParty table.

My problem is that each PartyId could have come from a different entity.

I need to know which Entity that PartyId comes from. i.e. Is it a contact or an account ?

There is probably a property that could be used. Does anyone know what I should add to the following FetchXML to add the entity that provided the partyid/partyname ?

<fetch mapping='logical'>
    <entity name='activityparty'>
        <attribute name='activityid'/>
        <attribute name='activitypartyid'/>
        <attribute name='partyid'/>
        <attribute name='partyidname'/>
        <attribute name='versionnumber'/>
        <filter>
            <condition attribute='versionnumber' operator='gt' 
                        value="@[User::v_ExtractNextStartVersionNumber]">
            </condition>
        </filter>
    </entity>
</fetch>

Thanks,

Jason

*This post is locked for comments

I have the same question (0)