Let say i am passing Doctype as"Customer", how this will hit econnect_out_Setup table and retrieve the information of Customer using joins
Is there any way to observe what are internal Joins written and queries executed while retrieving information using econnect?
*This post is locked for comments
Thanks a lot .....
Please provide any good online/offline/Books/Links resource regarding eConnect or Dynamics GP for Learning.
Funnily enough I have a post on that too...
http://www.timwappat.info/post/2015/12/22/eConnect-Customer-Requester-Document-No-ShipToName-field
See the section: "The document Updating the Transaction Requester for retrieve operations describes how to generate the stored procedures used by eConnect, following that guidance run the following SQL."
That linked eConnect documentation is well worth a read for naming conventions and understanding.
You must use the eConnectOutCreate procedure to generate the requester stored procedures if you are changing the rows in the setup table.
For other readers benefit:
The requester is a subsystem of eConnect that is helpful for basic data tracking and retrieval operations, importantly it can be customised by convention in the configuration (setup) table.
The custom XML nodes is a different approach in eConnect, departing from a "by configuration". It is a raw access to SQL stored procedures, allows both retrieval and updating of data in the database, permitting much more imaginative SQL in the stored procedures than that allowed by the simpler requester system.
Tim.
Ho okay Thank you.
I have a question for you.
We are manually writing procedures while creating custom XML nodes as referred by you in this link below community.dynamics.com/.../206876
But for retrieving as you said(For each row in the out table there is a stored procedure generated) may i know how these procedures are generated automatically while we insert a row into eConnect_Out_Setup?
I want to just know is there any tool to generate these stored procedures or this is also an internal mechanism?
If there is a tool to generate these procedures while retriving,is there a way to generate procedures while inserting as well?
Thanks
Sandeep K
If I understand you correctly, then you wish to see what SQL is generated by eConnect when using the eConnect_Out_Setup table to fetch data via a eConnect requester doc.
For each row in the out table there is a stored procedure generated, so for your example,
taRequesterCustomer1 is an example of the procedure that relates to the first customer row in the setup table.
The catch is that these procedures (and the procedure that generates them) are encrypted.
Using SQL profiler won't help either.
If you know how to decrypt stored procedures then this is the only option I can see you having.
Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (