script to show changes made to customer maintenance screen in ES

[lrousey]

Does anyone have a script that would show the changes that were made in the customer maintenence screen in ES? I'm trying to create a script that shows when a customer's status (active, blocked, inactive, etc) changes. Any help would be greatly appreciated.

Thanks!

L. Rousey

 

[dgillz]

This is a natural for Event Manager. Do you own Event Manager?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[crystalreporting]

SELECT EbcDataLog.Created, EbcProps.PropName, EbcDataLog.OldValue, EbcDataLog.NewValue, humres.fullname
FROM (EbcDataLog INNER JOIN EbcProps ON EbcDataLog.Property=EbcProps.PropId) INNER JOIN humres ON EbcDataLog.Creator=humres.res_id
WHERE EbcProps.PropName='CustomerStatus'

Peter Shirley

http://www.srhconsulting.com

 

[lrousey]

Thanks so much for the script. It worked!!!!

 

[lrousey]

I do have Event Manager. I plan on using it to notify my users when a customer has been taken off hold.

Thanks.

 

[lrousey]

The script that you sent does not show which cus_no or cus_name was changed. How can I add that to the script?

Thanks!

 

[lrousey]

I figured out what I needed to add to the script. I made an Inner Join on the cicmpy table.

Thanks again for your help!