Search for History Logged Field Updates
Type: MSSQL
Description: In this query we are searching for history records that were logged by GoldMine (because create a history log record for updates is checked in the field setup). In this particular case we are looking for key4 when it was changed from ‘DCS’ to ‘KES’ after June 1st 2006.
Note: This query needs to be rewritten using PATINDEX to account for varying start postions. In this case it works because all Rep IDs are 3 character.
- SELECT
- c1.contact
- ,c1.company
- ,c1.city
- ,c1.STATE
- ,c1.key4
- ,ch.REF
- ,ch.createon
- ,c1.accountno
- FROM
- contact1 c1 (NOLOCK)
- JOIN conthist ch
- ON c1.accountno=ch.accountno
- WHERE
- ch.createon > '06/01/2006'
- AND ch.resultcode= 'LOG'
- AND SUBSTRING(ch.REF,28,3) = 'DCS'
- AND SUBSTRING(ch.REF,37,3) = 'KES'
[link]
Leave a Reply
You must be logged in to post a comment.
