Creating Custom History Tracking Tables for Entities in SalesLogix Web

Field change tracking is implemented in a great way in SalesLogix 7.2 Web. You select the entity you want to track field change history to and then select the fields to audit. It’s that simple. You can also easily create your own custom tracking tables to record field changes to so you don’t have to overload the history table with all the tracked field changes.

For example, let’s say you have a Quote entity that you want to record field changes for to a custom tracking table. You can create a new entity called QuoteTracking to record to. On the QuoteTracking table create the following properties:

  • QuoteTrackingId (entity unique key added automatically)
  • QuoteId (this will hold the Quote.Id value for the quote the change was made on)
  • NewValue
  • Note
  • OldValue
  • FieldName

Now just go to the Quote entity and create a 1:M relationship from Quote.Id to QuoteTracking.QuoteId. On the Extended tab, you sould now see IQuoteTracking in the drop down for “Track History To” and can select it to record field changes to it (for whatever fields have the audited flag set on the Quote entity)

Want content like this delivered to your inbox? Sign up for our newsletter!
ABOUT THE AUTHOR

Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

1 Comment

  1. I tried this and it worked except for ID fields. I am auditing the Lead table and made some changes to Lead Owner, Lead Account Manager, and Lead Source none of which were recorded (made sure they were checked). I made changes to thinks like firstname and lastname and changes to these fields were recorded. Any idea on wihy it wouldn’t work on ID fields?

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *