Attempting to Replicate the "EmployeeFieldHistory" to Datalake via a replication set
to have available a list of name changes and have it reload in full once a week or so.
but i really would like to limit it to only things in the last 90 days or so
is there such a thing as having a condition like
(FieldName like "'%Name%'") and (create stamp.timestamp) >= today - 90 or getdate() - 90
or some way of having it only grab the last 90 days worth.
or do i have to somehow come up with an IPA and with java script updaate the "condition" or "Additional Condition" to have the date in the correct date format
via javascript or something in the RepSetBC business class for the correct replication.
