Declare index created duplicate records for old work-object save when code promoted to other env.
I have updated a Declare Index and added two fields in the declarative index rule (a property that belongs to a PageList). After deployment to TEST env. We ran activity "RecreateIndexesForClass" to populate newly added properties to the index.
After testing, when the work-object is updated the index created new rows instead of updating existing rows on save of work-object. It should have updated the existing rows.
The index is used in reports and this issue caused duplicate records in report output.