Dynamics Community Forum Thread Details

Add new filter on a personal view using JavaScript

Hi,

Is it possible to add new filter on a personal view using JavaScript?

I'm using D365 CE. Thank you in advance.

Hi,

Yes, you can add a filter condition in the personal view. Please find the below code to add a filter in fetchXml of personal view using javascript. The below function will return fetch XML which contains the filter condition which we have added. After successfully returning fetchXml you can directly execute the fetchXml using Web API.

var addFilterInFetchXML = function () {
    var filterXML = '';
   var fetchXml = "";
    try {
       //prepare existing fetchXML
        fetchXml ="<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>"+
        "<entity name='account'>"+
        "<attribute name='name'/>"+
        "<attribute name='telephone1'/>"+
        "<attribute name='address1_city'/>"+
        "<attribute name='primarycontactid'/>"+
        "<attribute name='statecode'/>"+
        "<link-entity name='contact' from='contactid' to='primarycontactid' visible='false' link-type='outer'    alias='accountprimarycontactidcontactcontactid'>"+
        "<attribute name='emailaddress1'/>"+
        "</link-entity>"+
        "</entity>"+
        "</fetch>";

        //covert fetchXML string to XML
        fetchXml = $.parseXML(fetchXml);

        //prepare filter condition as per your requirement
        filterXML += "<filter type='and'> <condition attribute='industrycode' operator='eq' value='1'>";
        filterXML += "</condition> </filter>";

        //add filter condition into actual fetchXML
        $(fetchXml).find('entity').append(filterXML);

        //convert XML into a string (fetchXML string)
        fetchXml = (new XMLSerializer()).serializeToString($(fetchXml)[0]);
    }
    catch (e) {
        throw new Error(e);
    }
      //return updated fetchXML which contains filter condition
   return fetchXml;
}

Hope this helps.

Thanks!

Quick Links