Linkedin = http://www.linkedin.com/in/mscrmexpert
Twitter = @mscrmexpert
Download from here http://crm2011odatatool.codeplex.com/
The CRM 2011 OData Query Designer is a Silverlight 4 application that is packaged as a Managed CRM 2011 Solution. This tool allows you to build OData queries by selecting filter criteria, select attributes and order by attributes. The tool also allows you to Execute the query and view the ATOM and JSON data returned.
The look and feel of this component will improve and new functionality will be added in the near future so please provide feedback on your experience.
1. Added dropdown list of available OptionSet values for a filter when of type OptionSet, Boolean, Status and State.
2. Attribute lists now show the UserLocalizedLabel Display Name instead of Schema Name.
3. Resolved issues with some attribute types not generating correctly when used in a filter.
Import this solution into CRM 2011 and you will see a new menu option 'OData Query Designer' within the Settings Area under Customization.
There are 3 items in the solution
1. A Silverlight application
2. A html webpage that hosts the Silverlight application
3. An update to Sitemap to set the menu option to be visible under Settings->CRM Tools
Note This release is currently in Beta so please provide feedback in the discussion area for any areas of improvement.
To take advantage of this functionality follow these easy steps:
You can find the tool on codeplex here.
If you have benefited from downloading and using this tool, please feel free to donate an amount of your choice.Regards,
|Core CRM functionality||Yes||Yes||Yes|
|Workflow & approval automation||Yes||-||Yes|
|Mobile customization & administration||Yes||-||Yes|
|Custom apps and websites (API access)||Yes||-||Yes|