I need to display dropdown of users within certain security role in my Dynamics Portal. In order to get list in my portal i am using fetchxml and it needs to link systemuser, systemuserroles and role entities. I was able to add read permission for systemuser and role entity in Portal > Entity Permission but i can't find 'systemuserroles' as one of the option under 'Entity Name' dropdown in Entity Permission page.
Does anyone know how i can achieve this?
Here is the fetch xml that i ran in XrmToolbox:
<fetch mapping="logical" count="50" version="1.0">
<entity name="systemuser">
<attribute name="fullname" />
<link-entity name="systemuserroles" from="systemuserid" to="systemuserid">
<link-entity name="role" from="roleid" to="roleid">
<filter>
<condition attribute="name" operator="eq" value="salesperson" />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>
Here is the fetch xml that i have in portal:
{% fetchxml feed %}
<fetch mapping="logical" count="50" version="1.0">
<entity name="systemuser">
<attribute name="fullname" />
<link-entity name="systemuserroles" from="systemuserid" to="systemuserid">
<link-entity name="role" from="roleid" to="roleid">
<filter>
<condition attribute="name" operator="eq" value="salesperson" />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>
{% endfetchxml %}
<tr>
<td>
User:
<select>
<option value="" disabled="disabled" selected="selected">- Please select a name -</option>
{% for item in feed.results.entities %}
<option value='{{item.systemuserid}}'>{{item.fullname}}</option>
{% endfor %}
</select>
</td>
</tr>
Portal > Entity Permission
Thank
Sanjeev
*This post is locked for comments
I have the same question (0)
