Notifications
Announcements
No record found.
How many and What are the db tables in msd crm
*This post is locked for comments
For all custom and native entities CRM internally created two tables
Let’s say for account entity, tables are
Accountbase
Accountextensionbase
And it internally creates two views,
Account
filteredaccount
Thanks,
Vijay waghmare
Thank You Vijay,
I Get my answer .
and Vijay i need to know how batch jobs created and works , as well as fetch xml .
If you are looking for something to run on schedule base then best option is to create windows scheduler for it. Create a console application that will perform your task and point generated .exe to windows scheduler that will run as per your scheduled time.
Fetchxml is another way of retrieving data from CRM entities through both client and server side. This is also useful for generating reports (especially for online CRM org), please refer below blog for more details
msdn.microsoft.com/.../gg328117.aspx
community.dynamics.com/.../fetchxml-reporting-in-microsoft-dynamics-crm-2011-part-2.aspx
Vijay Waghmare
Just a note. In the new crm 2013 it has introduced a change in database. Now each entity only has the "base" table that contains all the attributes. The "extensionBase" table disappeared.
Please answer
community.dynamics.com/.../117441.aspx
Thanks for information Alvaro.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
