Does anyone know if there is any way to filter the items returned by a view lookup filter?
See the example below. This user column view filter brings back all the user accounts in the Environment, including the system generated ones. This is really not liked by management (somewhat understandably).
It would be great to be able to apply something similar to what we can do with lookups on a form (e.g. limit the item returned to a nominated view).
I noticed that the classic editor does give you the opportunity to attach a web resource to the column and I tried the 'Java Script Query' code outputted by Fetch XML Builder, but this has no impact.
var fetchData = {
"teamid": "e16a07d8-249e-ec11-b400-000d3a5d38a2"
};
var fetchXml = [
"<fetch top='50'>",
" <entity name='systemuser'>",
" <attribute name='internalemailaddress'/>",
" <attribute name='fullname'/>",
" <link-entity name='teammembership' from='systemuserid' to='systemuserid' intersect='true'>",
" <filter>",
" <condition attribute='teamid' operator='eq' value='", fetchData.teamid/*e16a07d8-249e-ec11-b400-000d3a5d38a2*/, "'/>",
" </filter>",
" </link-entity>",
" </entity>",
"</fetch>"
].join("");
