Start a new topic
Answered

How to get last modified dates on attribute level?

I have fuzzy matched entity where I would like to track on golden record the last modified date for specific attributes.

For example if I have Contact entity that has attribute Email I would like to have attribute called EmailLastModifiedDate that would be automatically set for golden record every time the value of the email changes on the golden record level. 

What would be best way to achieve this?

Best Answer

To achieve such attribute level last modified dates , we can take use of named query

For your case, you can add this single attribut expression in the named query (no extra technical attribute needed) :
lookup first UpdateDate
    from GoldenHistoryRecords
    where FromBatchID=
        lookup
        max ToBatchID
        from CurrentGoldenRecord.GoldenHistoryRecords
        where CurrentGoldenRecord.FirstName<>FirstName
    end
end



In this case, you will check in all cases (Override or not) the correct UpdateDate.


also, enclosing the screenshot for same

1 Comment

Answer

To achieve such attribute level last modified dates , we can take use of named query

For your case, you can add this single attribut expression in the named query (no extra technical attribute needed) :
lookup first UpdateDate
    from GoldenHistoryRecords
    where FromBatchID=
        lookup
        max ToBatchID
        from CurrentGoldenRecord.GoldenHistoryRecords
        where CurrentGoldenRecord.FirstName<>FirstName
    end
end



In this case, you will check in all cases (Override or not) the correct UpdateDate.


also, enclosing the screenshot for same

Login to post a comment