In this file comments_status_lost_leaf_annots.sql there is a date value that needs to be adjusted for each update. This date should equal the date that the paint_annotation table was updated.
We should have this date auto-populated to reduce chances of forgetting to set it. Approach can be similar to issue https://github.com/pantherdb/fullgo_paint_update/issues/3 by reusing the profile.txt file, specifically adding a new line that records the date that make update_paint_paint_annotation is run.
In this file comments_status_lost_leaf_annots.sql there is a date value that needs to be adjusted for each update. This date should equal the date that the paint_annotation table was updated.
We should have this date auto-populated to reduce chances of forgetting to set it. Approach can be similar to issue https://github.com/pantherdb/fullgo_paint_update/issues/3 by reusing the profile.txt file, specifically adding a new line that records the date that
make update_paint_paint_annotationis run.