When a deal is merged, the deal that remains will have these fields like this: Deal id: 4011798071 hs_merged_object_ids: 3988824107;3983739007; However, the deals 3988824107 and 3983739007 are still in the deal table. This is an example from my warehouse. Would it be possible to add a boolean is_merged field to the deals table so I can filter them out like you have an is_deleted field on many tables? Now I have to create a view by listing all ids that can be found in hs_merged_object_ids and joining it back to the raw deal table which was a very complex query to write.
Please sign in to leave a comment.