Sign in

Microsoft.com

Microsoft

Remove From My Forums

Add non searchable fields in a view

Question
0

Sign in to vote

Is there a way to add a non searchable field in the view?

I want to create a view of merged contacts (Active and subordinate contact which is inactive after merge)

I searched for the fields in audit history which were responsible for holding the old and new values,but they are non searchable.

Any idea in which way to proceed?

Monday, October 3, 2016 10:35 AM

All replies

0

Sign in to vote
Hi,

This has to do with the fact how CRM stores the data in SQL Server. Because it is a rather generic table, there is no filtered view available which is used for the "export to excel" and "advanced view" functionality. You could write a query against the database (only onpremise) or use the SDK (some methods are available for this) to retrieve the info.

https://msdn.microsoft.com/en-us/library/gg309735.aspx
Audit report in SSRS
https://marcuscrast.wordpress.com/2012/01/14/dynamics-crm-2011-audit-report-in-ssrs/
- Edited by Jigar Patel 04 Thursday, October 13, 2016 6:37 PM Added Link
Thursday, October 13, 2016 6:34 PM