Is there a way to use PI-RDBMS when the source table will have some of its fields updated after the insert?
Works well when records are inserted but the problem is that I need to update tags at the timestamp of the insert when original record is updated.
It is about the reel table in a replix database. reels are created with some fields at null and after a while, they are updated.
I thought about using a trigger on the source table and use a custom table to store inserted and updated timestamp and key and do a join using that table and the source but I haven't yet figured it out completely.
If someone has ever done something like this...