Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Custom filter on SubGrid (not like the good old days) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I want to add a custom filter and layout to a subgrid in CRM. I have done this several times before with javascript but now it seems like this functionality has been removed. 

    All I can find is "setCurrentView" for subgrids. But as I interperet this I can only change between existing views.

    What I want to accomplish:

    I have three entities:

    • Account 
    • HelpText 
    • MarketingArea

    On the Account entity I want to display a subgrid thats showing all HelpTexts thats connected to the Account. I also want to show all HelpText thats connected to the same MarketingArea thats set in a lookup on Account. 

    Above text explained in javascript/fetchXml:

    var accountId = "57b1950f-f7a2-4aad-a15b-138fdf99bdce";
var marketingAreaId = "8d88b2f8-ff21-4970-9d99-fb5c0bddcfc5";

var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>";
fetchXml += "<entity name='x_helptext'>";
fetchXml += "<attribute name='x_name' />";
fetchXml += "<filter type='or'>";
fetchXml += "<condition attribute='x_accountid' operator='eq' value='" + accountId + "' />";
fetchXml += "<condition attribute='x_marketingareaid' operator='eq' value='" + marketingAreaId +"'/>";
fetchXml += "</filter>";
fetchXml += "</entity>";
fetchXml += "</fetch>";

    Anyone have an idea on how to accomplish this?

    Thanks in advanced!


    Tuesday, November 8, 2016 1:13 PM

All replies