Change all Views

Posted on June 29th, 2007 in Allgemein by Seidl Michael | 2,473 views | View blog reactions

Today I tell you about a little Trick, where you can edit all Views in Microsoft CRM, also that, you will not be able within CRM.

So, at normal way, you can only edit the Main Views, for example, Contacts, Accounts, Activities. But what if you want to edit the View “All Members” within the Marketinglist?
So you are not able to edit this View in Microsoft CRM, but with the next step, you can Edit all Views in Microsoft CRM, and the best thing, its official supported by Microsoft.

1. Start the Query Analyzer (SQL 2000), or the Managment Studio (SQL 2005).

2. Make a Query with the following string against the Database “Companyname_MSCRM”.

SELECT SavedQueryId FROM SavedQueryBase WHERE (Name = ‘All Members’) AND (ReturnedTypeCode = ‘2′)

3. You will get a GUID, which you put in the following URL, and now you can edit the View you want. After that don’t forget to Publish the Entity.

http:///tools/vieweditor/viewManager.aspx?id={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}