Is there a way to track History of master record changes and add it as a validation : Portal

Start a new topic

Is there a way to track History of master record changes and add it as a validation

Aishwarya WALIA

started a topic 2 days ago

I am looking to establish a way to track changes to master records such that if the latest value of some fields in a master record is different from its previous version, it raises a validation error and the data stewards are requested to review linked golden records.

Is it possible to compare values of CurrentMasterRecord and oldMasterRecord as a validation?

1 Comment

Alexia SIMOND

said 1 day ago

Hello Aishwarya,

This article is laying the foundations of how to report on data differences between two points in time:

https://support.semarchy.com/a/forums/topics/43000531280

As you'll see, the easiest way is to base yourself on the MH table, in your case as you want to monitor master change.

Then it will be up to you to explore the semql capabilities to try and meet your requirement.

Maybe something thanks to lookups?

https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/SemQL/related-entities-attributes.html#_lookup_expression

If you need further assistance to deep dive in your need and model, feel free to open a ticket and we'll put you in contact with our trusted Professional Services team, who are well equipped to help you on those implementation questions.