Need to query Audit history for opportunity entity

All replies

• 

  

  0

  Sign in to vote

  To achieve this you could do a join on the "Audit Base" table and "Opportunity" table. Both tables exist with the mentioned names. The object id of the audit table is common with the id of the entities (here is opportunities).

  ---

  
  My Weblog | My Website

  • Marked as answer by Payman BiukaghazadehEditor Tuesday, May 28, 2013 3:24 PM

  Thursday, May 23, 2013 8:10 PM

  Moderator
• 

  

  0

  Sign in to vote

  The audit base table has different column names.

  I just need the old value, new value, changed filed name.

  How to I get these fileds.

  Thursday, May 23, 2013 11:36 PM
• 

  

  0

  Sign in to vote

  Hi,

  Try this link,it will help you,

  http://a33ik.blogspot.in/2011/11/crm-2011-reports-on-data-auditing.html

  ---

  VidhiyaM

  • Proposed as answer by VidhiyaM Friday, May 24, 2013 4:49 AM
  • Marked as answer by Payman BiukaghazadehEditor Tuesday, May 28, 2013 3:24 PM

  Friday, May 24, 2013 4:49 AM
• 

  

  0

  Sign in to vote

  http://a33ik.blogspot.in/2011/11/crm-2011-reports-on-data-auditing.html

  when I tried this post I am getting an error

  Invalid length parameter passed to the LEFT or SUBSTRING function

  anyone knows how to resolve this error.

  Friday, May 24, 2013 6:30 PM