ODataQueryDesignerJSON Tab

8 Responses to ODataQueryDesignerJSON Tab

  1. Mike Kolling says:

    Hi

    Sorry if I am being a bit thick, but could I use this to fill an iframe with data derived from the javascript generated in the JSON result?

    The scenario i have is :-

    Contacts is child of Accounts and I have a custom entity “downloads” as child of Contacts.

    So I can add Downloads against the Contact.

    How can I show all the downloads from all the contacts against the account?

    Can this tool help me do this?

    Mike

    • You could definitely use the OData query generated using this tool to retrieve the results using JavaScript on the onload event of the Account entity, though you would then have to present the results in a grid or similar to the user. You could do this a number of ways though here is one example of jQuery Templates that might help.

      Using FetchXml in an IFrame was a big CRM 4 “thing” like this but was unsupported and I cannot verufy that it works in 2011. If it does work then this would probably meets your needs better as you would get a nice CRM Grid.

  2. Mike Kolling says:

    Hi

    The

    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 } } )

    line does not work, it complains that it does not know what “advFind” is – I guess object names have changed.

    Mike

    • Use contentIFrame prefixed like so

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

  3. Mike Kolling says:

    Thats it, works a treat….thanks!!

  4. BASHALA says:

    Please i need to know how to use the JSON code in javascript?

    Thank in advance.

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