Display Fetch in Iframe

The fetch viewer is a very handy utility class that accepts advance find parameters and “injects” the result into any IFRAME.

The nice thing about it is that it does not require any server side deployment (no code behind). The code creates a dynamic FORM fills the required advanced find parameters and submits the request to the fetchdata.aspx which is the advanced find result page. The code also takes care of iframe padding and presents a loading gif until the page is rendered.

In order for this to work you need to specify all the required parameters such as FetchXml , LayoutXml , EntityName and the DefaultQueryId for the requested entity. The idea is to create a complete request using the advanced find window, concatenate fetchxml dynamic values, assign the predefined masterpiece to the FetchViewer class and use the Refresh method to finish the job.

You can get the fetch parameters by pasting the following code in the advanced find window addressbar.

javascript:void( new function(){ prompt("Fetch Parameters:",getFetchParams());function getFetchParams(){ return "FetchXml:\n" + advFind.FetchXml + "\n\n" + "LayoutXml:\n" + advFind.LayoutXml + "\n\n" + "EntityName:\n" + advFind.EntityName + "\n\n" + "DefaultAdvancedFindViewId:\n" + advFind.DefaultAdvancedFindViewId } } )

Please notice, I’ve revised the code to support iframe positioning on any tab.
Iframes that aren’t located on default tab should be handled a bit differently since the iframe url is handled by crm (even if the initial url is about:blank).

When the form loads call the RegisterOnTab with the iframe position tabIndex. If the iframe is located on the default tab the refresh method will be called immediately otherwise crm will trigger the onreadystatechange event which will eventually call the Refresh method. The RegisterOnTab should be called only once per iframe and only from the onload event. Afterwards, if you need to revise the iframe Display call the iframe FetchViewer.Refresh method directly.

I upgraded the FetchViewer class and now it supports parent context (mapping) and grid refresh. You can read more about it here

function OnCrmPageLoad()
{
   window.fetchAccounts = new FetchViewer("IFRAME_test1");
   fetchAccounts.FetchXml  = getFetchXml();
   fetchAccounts.LayoutXml = getLayoutXml();
   fetchAccounts.Entity    = "account";
   fetchAccounts.QueryId   = "{00000000-0000-0000-00AA-000010001001}";
   fetchAccounts.RegisterOnTab(0); //IFRAME ON THE DEFAULT TAB

   window.fetchAccounts1 = new FetchViewer("IFRAME_test");
   fetchAccounts1.FetchXml  = getFetchXml();
   fetchAccounts1.LayoutXml = getLayoutXml();
   fetchAccounts1.Entity    = "account";
   fetchAccounts1.QueryId   = "{00000000-0000-0000-00AA-000010001001}";
   fetchAccounts1.RegisterOnTab(2); //IFRAME ON THE THIRD TAB (index eq 2)
 
   crmForm.all.gi_name.attachEvent( "onchange" , WhenThisFieldChangesAndCallRefresh );
}

function WhenThisFieldChangesAndCallRefresh()
{
   //Change the fetchAccounts.FetchXml ( for example ) and Refresh
   fetchAccounts.Refresh();
}

function getFetchXml(){
   return '<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"><entity name="account"><attribute name="name"/><attribute name="address1_city"/><attribute name="primarycontactid"/><attribute name="telephone1"/><attribute name="accountid"/><order attribute="name" descending="false"/><filter type="and"><condition attribute="ownerid" operator="eq-userid"/><condition attribute="statecode" operator="eq" value="0"/></filter><link-entity name="contact" from="contactid" to="primarycontactid" visible="false" link-type="outer" alias="accountprimarycontactidcontactcontactid"><attribute name="emailaddress1"/></link-entity></entity></fetch>';
}

function getLayoutXml(){
   return '<grid name="resultset" object="1" jump="name" select="1" icon="1" preview="1"><row name="result" id="accountid"><cell name="name" width="300" /><cell name="telephone1" width="100" /><cell name="address1_city" width="100" /><cell name="primarycontactid" width="150" /><cell name="accountprimarycontactidcontactcontactid.emailaddress1" width="150" disableSorting="1" /></row></grid>';
}

function FetchViewer( iframeId )
{
   var Instance = this;
   var vDynamicForm;
   var m_iframeTab;
   var m_iframeDoc;
  
   Instance.Entity    = "";
   Instance.Iframe    = null;
   Instance.FetchXml  = "";
   Instance.QueryId   = "";
   Instance.LayoutXml = "";
  
   Instance.RegisterOnTab  = function( tabIndex )
   { 
      Instance.Iframe = document.getElementById( iframeId );  
  
      if( !Instance.Iframe )
         return alert( "Iframe " + iframeId + " is undefined" );

      m_iframeDoc = getIframeDocument();
      var loadingGifHTML  = "<table height='100%' width='100%' style='cursor:wait'>";
      loadingGifHTML += "<tr>";
      loadingGifHTML += "<td valign='middle' align='center'>";
      loadingGifHTML += "<img alt='' src='/_imgs/AdvFind/progress.gif'/>";
      loadingGifHTML += "<div/><b>Loading View...</b>";
      loadingGifHTML += "</td></tr></table>";
      m_iframeDoc.body.innerHTML = loadingGifHTML;

      if( parseInt( "0" + tabIndex ) == 0 ) Instance.Refresh();
      else Instance.Iframe.attachEvent( "onreadystatechange" , RefreshOnReadyStateChange ); 
   }
 
   function RefreshOnReadyStateChange()
   {
      if( Instance.Iframe.readyState != 'complete' )
         return;
  
      Instance.Refresh();
   }
  
   Instance.Refresh = function()
   {
      if( !Instance.Iframe )
         return alert( "Iframe " + iframeId + " is undefined" );
  
      m_iframeDoc = getIframeDocument();  
  
      Instance.Iframe.detachEvent( "onreadystatechange" , RefreshOnReadyStateChange );
     
      var create  = m_iframeDoc.createElement;
      var append1 = m_iframeDoc.appendChild; 
      vDynamicForm = create("<FORM name='vDynamicForm' method='post'>");
  
      var append2 = vDynamicForm.appendChild;
      append2(create("<INPUT type='hidden' name='FetchXml'>"));
      append2(create("<INPUT type='hidden' name='LayoutXml'>"));
      append2(create("<INPUT type='hidden' name='EntityName'>"));
      append2(create("<INPUT type='hidden' name='DefaultAdvFindViewId'>"));
      append2(create("<INPUT type='hidden' name='ViewType'>"));
      append1( vDynamicForm );

      vDynamicForm.action = prependOrgName("/AdvancedFind/fetchData.aspx");
      vDynamicForm.FetchXml.value   = Instance.FetchXml;
      vDynamicForm.LayoutXml.value  = Instance.LayoutXml;
      vDynamicForm.EntityName.value = Instance.Entity;
      vDynamicForm.DefaultAdvFindViewId.value = Instance.QueryId;
      vDynamicForm.ViewType.value = 1039;
      vDynamicForm.submit();
   
      Instance.Iframe.attachEvent( "onreadystatechange" , OnViewReady );
   }
  
   function OnViewReady()
   {
      if( Instance.Iframe.readyState != 'complete' ) return;
  
      Instance.Iframe.style.border = 0;
      Instance.Iframe.detachEvent( "onreadystatechange" , OnViewReady );
      m_iframeDoc = getIframeDocument();
      m_iframeDoc.body.scroll = "no";
      m_iframeDoc.body.style.padding = "0px";   
   }

   function getIframeDocument(){
      return Instance.Iframe.contentWindow.document;
   }

}

OnCrmPageLoad();