Multiple versions of same documents with different effective dates
I am trying to keep multiple versions of same document (empId,
empName,deptID,effectiveDt,empTitle..,..) with different effective dates
(composite key: deptID,empID,effectiveDt) but mark/ soft delete (deleted=Y)
the older ones and keep deleted=N for the latest one.
This way i can query the latest one (....AND deleted=N) and if required
show all of them.
I am thinking to do this in processAdd / ScriptUpdateProcessor and query
Solr to first see if there is any existing record with deptID,empID and
then update those with deleted=Y and then process new one with deleted=N.
Any suggestions or issues you see with this approach?
P.S. I need to figure out how update another document same time