Duplicate records in HIFIS_Client_Services for Diversion
complete
Ali Ryder
Editing
a Diversion record results in duplicated records in HIFIS_Client_Services.This is a bigger issue than it would seem due to https://acreconsulting.canny.io/hifis-4/p/save-diversion-attempt-returns-to-edit-screen and then subsequently https://acreconsulting.canny.io/hifis-4/p/canceling-the-edit-diversion-makes-it-abandoned
Ali Ryder
complete
Fixed in 4.0.60.2
Ali Ryder
From Ryan Booker: For some reason when editing the diversion, HIFIS is adding new rows to the HIFIS_Client_Services table and duplicating the serviceID. Each edit seems to double the number of duplicate records added to the HIFIS_Client_Services table.
Ali Ryder
Query:
SELECT d.DiversionID,
d.PrimaryClientID,
s.ServiceID,
cs.ClientServiceID,
cs.ClientID
FROM HIFIS_Diversions d
INNER JOIN HIFIS_Services s ON d.ServiceID = s.ServiceID
INNER JOIN HIFIS_Client_Services cs ON s.ServiceID = cs.ServiceID
ORDER BY d.DiversionID