BIX can do updates in same record instead of inserting duplicate record in table when same case/transaction updated.
we have created a below table in BIX Database. Its allowing to insert duplicate records into the table when ever the same case/transaction has update. so as my requirement we need to store/capture the final update of the case/transaction into table.
It will be great if someone helps us with resolution.
If you only want the final, resolved state why not just setup the filter on your extract rule to only extract the instances that meet that criteria? Or is it that you want to always have the latest version even if it is not resolved?