locked
OData Query Designer RRS feed

  • Question

  • hi,

     i have installed odata query designer,i generated the code,but i need the required steps to add code to my datagrid in the dashboard, 

    my datagrid in dashboard:>


    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]

    Wednesday, March 11, 2015 11:06 AM

Answers

All replies

  • Hi,

    i'm beginner in crm development, i created a web resources contains this component:>

    i insert in my dashboard, but this is a static component (no interaction with CRM), i need the steps required to :

    - Get and verify the opportunity statecode, opportunity actualvalue, opportunity  CreatedBy and the sum of the each sales agent each 3 months.

    - After verify the data, i need to import in the my DataGrid in the dashboard.

    any idea ?


    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]


    Wednesday, March 11, 2015 8:38 AM
  • Hello,

    To build Odata ther easiest way is to use OData builder. I use following - https://crmrestbuilder.codeplex.com/


    Dynamics CRM MVP
    My blog

    Wednesday, March 11, 2015 8:44 AM
    Moderator
  • Hi,

    using XrmSvcToolkit (https://xrmsvctoolkit.codeplex.com/)

    You can retrieve any data, you need. Then, using js, you can put it into your datagrid.

    Or you can use this article:

    https://msdn.microsoft.com/en-us/library/gg309461.aspx

    and .ajax to retrieve entities without XrmSvcToolkit.

    • Edited by xjomanx Wednesday, March 11, 2015 8:58 AM
    Wednesday, March 11, 2015 8:50 AM
  • Hello,

    To build Odata ther easiest way is to use OData builder. I use following - https://crmrestbuilder.codeplex.com/


    Dynamics CRM MVP
    My blog

    i need more documentation to use crmrestbuilder, thanks.

    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]

    Wednesday, March 11, 2015 9:09 AM
  • i downloaded and try to install crmrestbuilder, but not compatible with my crm 2013 build 6.0.0 !

    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]


    • Edited by Ammar.Zaied Wednesday, March 11, 2015 9:17 AM
    Wednesday, March 11, 2015 9:14 AM
  • i need more documentation to use crmrestbuilder, thanks.
    I believe documentation section contains all required information. Also you can recheck blog post of tool author - http://jlattimer.blogspot.com/2014/10/crm-rest-builder-v1000.html

    Dynamics CRM MVP
    My blog

    Wednesday, March 11, 2015 9:18 AM
    Moderator
  • thanks for reply quickly, the xrmsvctoolkit compatible with crm 2011, my version 2013 build 6.0.0

    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]

    Wednesday, March 11, 2015 9:19 AM
  • thanks for reply quickly, the xrmsvctoolkit compatible with crm 2011, my version 2013 build 6.0.0
    Just for your information. XrmSvcToolkit is compatible with CRM 2011/2013/2015. Use it in work on a daily basis.

    Dynamics CRM MVP
    My blog

    Wednesday, March 11, 2015 9:22 AM
    Moderator
  • hi ammar,

    try the odata query designer, i have installed in CRM 2013. And also a big fan of xrmservicetoolkit. Makes life so easy.

    https://crm2011odatatool.codeplex.com/

    regards

    Jithesh

    • Marked as answer by Ammar.Zaied Wednesday, March 11, 2015 11:06 AM
    Wednesday, March 11, 2015 9:52 AM
  • hi ammar,

    try the odata query designer, i have installed in CRM 2013. And also a big fan of xrmservicetoolkit. Makes life so easy.

    https://crm2011odatatool.codeplex.com/

    regards

    Jithesh

    Hi Jithesh,

    yes i have installed odata query designer,i generated the code,but i need the required steps to add code to my datagrid in the dashboard, thanks.


    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]


    • Edited by Ammar.Zaied Wednesday, March 11, 2015 11:30 AM
    Wednesday, March 11, 2015 10:37 AM
  • Dear Ammar,

    Please don't create duplicated threads. I will merge your threads and please try not to create different variations of the same question in different threads.


    Dynamics CRM MVP
    My blog

    • Marked as answer by Ammar.Zaied Wednesday, March 11, 2015 11:29 AM
    • Unmarked as answer by Ammar.Zaied Wednesday, March 11, 2015 11:30 AM
    Wednesday, March 11, 2015 11:27 AM
    Moderator
  • You can recheck following articles and check mentioned samples:

    https://msdn.microsoft.com/en-us/library/gg985387.aspx

    https://msdn.microsoft.com/en-us/library/gg327904.aspx


    Dynamics CRM MVP
    My blog

    • Marked as answer by Ammar.Zaied Wednesday, March 11, 2015 12:42 PM
    Wednesday, March 11, 2015 11:31 AM
    Moderator