Load subgrid based on another Look up error
Question
All replies
-
Hi all,
i am trying to Load Subgrid Value based on another Lookup in CRM2013. But I can't able to Achieve that. Steps i have done below
Function onload()
{
subgridprojectidload()
}
function subgridprojectidload() {
var grid = document.getElementById('ProjectID');
if (grid == null) {
setTimeout('subgridprojectidload()', 2000);
}
else {
var lookupfield = new Array;
lookupfield = Xrm.Page.getAttribute("new_financeidid").getValue();
if (lookupfield != null) {
var lookupid = lookupfield[0].name;
}
else {
return;
}
var fetchXml = "<fetch distinct='false' mapping='logical' output-format='xml-platform' version='1.0'>";
fetchXml += "<entity name='new_projectid'>";
fetchXml += "<attribute name='new_projectidid'/>";
fetchXml += "<attribute name='new_name'/>";
fetchXml += "<attribute name='createdon'/>";
fetchXml += "<order descending='false' attribute='new_name'/>";
fetchXml += "<filter type='and'>";
fetchXml += "<condition attribute='new_name' value='%" + lookupid + "%' operator='like'/>";
fetchXml += "</filter>";
fetchXml += "</entity>";
fetchXml += "</fetch>";
grid.control.SetParameter("fetchXml", fetchXml);
grid.control.refresh();
}
}Eg: In lookup iam having a value as 22254 means in Subgrid i need to load the values which contain (22254)
( ie )22254_2222_Adfkasdkfklnmasdf
What's the error you are getting? Subgrid is empty or JS sends some error. Please provide detail. And also make sure that your subgrid Data Source settings, use All Record Types. In this example, I am using Open Activities as the default view but you can use which ever suites your needs.
I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.
Mubasher Sharif
Check out my about.me profile!
http://mubashersharif.blogspot.com
Linked-In Profile
Follow me on Twitter!
