locked
Extracting query for excel sheets RRS feed

  • Question

  • Not really sure whether this should be in the Excel or the CRM forum...
    I have some excel sheets which are dynamically linked with MS CRM, and refresh when I press the refresh from CRM button on the ribbon.
    Thing is, im not sure what the queries being sent are.

    Is there any way for me to access the queries being sent to CRM from which the data is being refreshed ?

    Monday, June 4, 2012 8:55 AM

Answers

All replies

  • Hi,

    Yes you can access the query, follow these steps:

    1. In Excel sheet click on Data->Connections

    2. Select Connection and click on Properties button

    3. Click on Definition tab and look in Command text field for query


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".


    Monday, June 4, 2012 8:59 AM
  • I don't know whether this is because we are using CRM Online, but the Command Text field is a complete blank :(

    

    Monday, June 4, 2012 9:23 AM
  • Hi,

    SQL Qeury  is only available for CRM On Premise version and CRM online does not execute any Query directly on DB but rather than uses CRM Excel add-on (installed with Outlook client) for retrieving/Refreshing data.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".




    Monday, June 4, 2012 9:26 AM