Using the Advanced Find for FetchXML builder

Posted: September 8, 2010 in Advance Find, FetchXml, JScript, Microsoft Dynamics CRM
Tags: , ,

You can just open the Advanced find page and build the query as you like. Then run the query to see if it returns the data as you wish it should. If you are satisfied with the results and you want to know what query was sent into the CRM Framework, then press F11 to get the address bar and enter this script and press enter.

javascript:alert(resultRender.FetchXml.value);

If you get a warning about leaving the page, just press ‘ok’ and then the query which is sent to the framework opens up in a popup. Unfortunately you cannot select the text to copy and paste. But with Windows XP and Windows Server 2003 you can copy all text on the popup by clicking somewhere on the popup (not on the button “OK” ofcourse) and pressing ctrl+c. Now in notepad you can paste the text of the FetchXML.

Good luck!

You can also try this instead of the alert:

javascript:prompt(“my query:”, resultRender.FetchXml.value);

Advertisements
Comments
  1. […] Posted in FetchXml, JScript, Microsoft Dynamics CRM | Tags: Custom Lookup, Dynamic Lookup, FilteredLookup, Filtering Lookup, Multiple Custom Lookup « Using the Advanced Find for FetchXML builder […]

  2. Marie Chelle says:

    Thank you very much my friend, you are very kind in sharing this useful information with? others…. he details were such a blessing, thanks.

  3. Murthy Puvvada says:

    You are a life saver dude… thanks…

  4. Eve says:

    can we filter createdon last 3 days but not yesterday? anyway to do it via modifying the fetchxml query?

  5. Shubh says:

    Please describe in detail…….

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s