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.
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.
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With