Hi,
I need to create a report on audit history, i am able to get the old value from changeddata in audit table.
How can i get the new value?
Thanks,
Arjun
arjun
The change data only stores the old value - you need to look at the next audit record or the current record to get the new value.
See - http://a33ik.blogspot.co.uk/2011/11/crm-2011-reports-on-data-auditing.html
Hope this helps,
Scott
Scott Durow Blog www.develop1.net Follow Me Rockstar365 If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
I saw this link everywhere but i need to set sql query like Audit View of CRM.
Please help,
thanks