Service Connections creating duplicating records when toggled

[Gareth Cantrell]

When changing the service connections for a service via the UI, new records are being created in the database.

In the below screenshot from "Database Direct", the original records for service id 13 are h_id's: 7, 8 & 9.

Selecting the "All" button for all permutations in the service has caused additional rows to be created. This has the downside of not allowing connections to see the timeline or comment as expected when we've supposedly allowed collaboration.

I have had to manually delete records from the database using the "data:deleteRecord" API to get this working as expected, so that the database looks like the 2nd screenshot below.

{
	"@service": "data",
	"@method": "deleteRecord",
	"params": {
		"application": "com.hornbill.servicemanager",
		"table": "h_itsm_service_connections",
		"keyValue": ["9","597","600","7","595","598","8","596","599"]
	}
}

Table1: Incorrect

Table2: Correct - after running "data:deleteRecord" API

[ArmandoDM]

Good evening  @Gareth Cantrell

thank you for reporting this issue.
We were able to replicate it.
This has been fixed now and the fix will be availble in the next build.

Regards

Armando