Many times (especially when we started Dync CRM) and ask us to reports from Visual Studio, know the names of the tables, attributes, or simply we have no experience doing queries BD. In a post previous FetchXML showed how to get the views and advanced searches, now I'll show you how to get the SQL statement.
First make an advanced search (or select a view) and export it to Excel by selecting "Dynamic Worksheet" (Dynamic worksheet).
When we open Excel export the result, we will select the option "Data" ribbon and then select the "Connections."
then open a window in which we will click on the "Properties ..."
In the next window, select the tab "Definition", which in section "Command Text" shows the SQL
0 comments:
Post a Comment