Is it a way to identify the users who added members in a static marketing list ?
I would like to have a view of all contacts that are members of a marketing list with the contact name, its company and the user who added the member.
The advanced find does not give me access to the List Member entity.
Therefore, I built a FetchXML based on following entities:
- List
- ListMember
- Contact and Account
- SystemUser (who created the ListMember)
- ListMember
<fetch count="50">
<entity name="list">
<attribute name="listname" />
<filter>
<condition attribute="listname" operator="begins-with" value="SQ" />
</filter>
<link-entity name="listmember" from="listid" to="listid" alias="lm" intersect="true">
<link-entity name="systemuser" from="systemuserid" to="createdby" alias="su">
<attribute name="fullname" />
</link-entity>
<link-entity name="contact" from="contactid" to="entityid" alias="c" intersect="true">
<attribute name="fullname" />
<link-entity name="account" from="accountid" to="parentcustomerid" alias="a">
<attribute name="name" />
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>
The results are good.
Unfortunately, when I try to publish this view using the XrmTools View Designer, I can only see ONE record.