Hi Experts,
I want to filter subGrid result but gettign query builder error
I copied the XML from Advanced find
PFB Code, kindly cross check FetchXML
function filterAssignedResourceGrid(executionContext) {
var formContext = executionContext.getFormContext();
var gridContext = formContext.getControl("availablebookableresource");
if (gridContext == null) {
setTimeout(function () {
FetchViaName(executionContext);
}, 2000);
return;
} else {
debugger;
var roleID = Xrm.Page.getAttribute("new_ptojecttask").getValue()[0].id
if (roleID != null) {
var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>" +
" <entity name='msdyn_projectteam'>" +
" <attribute name='msdyn_projectteamid' />" +
" <link-entity name='bookableresource' from='bookableresourceid' to='msdyn_bookableresourceid' visible='true' link-type='outer' alias='a'>" +
" <attribute name='name' />" +
" </link-entity>" +
" <link-entity name='msdyn_resourceassignment' from='msdyn_projectteamid' to='msdyn_projectteamid' link-type='inner' alias='b'>" +
" <filter type='and'>" +
" <condition attribute='msdyn_taskid' operator='eq' uiname='qwerty 1' uitype='msdyn_projecttask' value='{9B069346-DE61-EA11-A811-000D3A5AC0B3}' />" +
" </filter>" +
" </link-entity>" +
" </entity>" +
"</fetch>";
gridContext.setFilterXml(fetchXml);
gridContext.refresh();
}
}
}
