In which table MS CRM system views are stored?

sql-server dynamics-crm-2011
jayt.dev picture jayt.dev · Jun 16, 2015 · Viewed 9.7k times · Source

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.

Answer

James Wood picture James Wood · Jun 16, 2015

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

Related questions

Where does Microsoft Dynamics CRM store OptionSet values in SQL Server?

I'm doing a data migration in to Microsoft Dynamics CRM 2011 and need to perform reconciliations against the source to ensure that everything loaded successfully. To do this I am querying the SQL directly in SQL Server, but I can't seem …

Read More
Error" ...The OLE DB Source.Outputs[OLE DB Source Output].Columns[XXXXXXXX] on the non-error output has no corresponding output

Ive spent hours trying to fix this issue. For the column that's giving me the problem i am using a scalar-function in sql server to grab the name. The function is correct and works fine. I then use a stored …

Read More
How to Inner join with query expression crm

I'm trying to do a simple inner join with Query Expression. I'm trying to covert this query with QE but I got always the same error. I'm doing this QE: Entity Role = new Entity(); Role.LogicalName = "role"; Entity SystemUserRoles = new …

Read More