Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

In which table MS CRM system views are stored?

I am looking for the table that holds the criteria records for MS Dynamics CRM system views or saved Advanced Find views. Every saved view (system view or custom view) has some criteria that are used to filter the results. I would like to find the table in the database that holds this criteria as records.

like image 997
jayt.dev Avatar asked Jun 16 '15 11:06

jayt.dev


People also ask

What is views in MS CRM?

With Dynamics 365 Customer Engagement (on-premises), use views to define how a list of records for a specific entity is displayed in the application. A view defines: The columns to display. How wide each column should be.

Where does Dynamics CRM store data?

Now, there are a couple of ways that data storage can be implemented. Two of the most common methods are using either Microsoft's online servers or a hosted version. The hosted version is an onsite version that could be on your own servers, on your premises or on a hosted private data cloud.

How do you view table data in Business Central?

To view a table, you add the table=<TableID> parameter to the client's address (URL), replacing <TableID> with the ID of the table that you want to view.


1 Answers

System views are stored inside SavedQuery

https://msdn.microsoft.com/en-gb/library/gg594431.aspx

User views (saved from Advanced Find) are stored inside UserQuery

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

like image 106
James Wood Avatar answered Sep 21 '22 04:09

James Wood