-
Using Filtered Views with CRM 3.0
Some of my customers use Microsoft Excel or Access to pull data from the CRM system in order to produce custom reports, or in one instance, to interface with a third-party bulk-email application.
CRM 3.0 has a set of SQL Database Views, called Filtered Views, that are constructed in such a way that CRM Security roles are maintained and you can retrieve nothing using one of these views that you would not ordinarily see while using the CRM application.
One aspect of using filtered views that you must take into consideration is the fact that all data ( that you have access to ) will be retrieved from the specified Entity. This means both Inactive and Active records.
If you don't take Inactive records into consideration your result set could be drastically different than what you expected and you may inadvertently expend resources on inactive customers.
Luckily, CRM provides two data fields that can be used to filter your query:
SQL Column Value statuscode 1 = Active 2 = Inactive
statuscodename Active or
Inactive
So, here is how you would use the above:
This code instructs SQL Server to return all rows where the statuscode is equal to 1, which is an Active Account or Contact.
Dynamics CRM, Reporting
(No Ratings Yet)3,590 views
Loading ...4 responses to “Using Filtered Views with CRM 3.0”
-
abdullah January 18th, 2008 at 08:23
Hi
What is the difference in Views and Filtered View?? -
Filtered Views are accessed directly from SQL. Views, in CRM terminology, are a view of the data from within the CRM user interface.
-
Ricerca nelle viste anche degli Accounts inattivi « Marcello Tonarelli Blog April 27th, 2008 at 14:47
[...] http://blogs.infinite-x.net/2006/09/07/using-filtered-views-with-crm-30/ [...]
-
Maria May 8th, 2008 at 05:19
Why use statuscode instead of statecode? Is there any difference between the two (i.e. can one show "active" while the other shows "inactive")?
Leave a reply
-
Loading ...