Update Instance Status to Expired
We are using below script to update the Instance status to 'Expired' instead of through Update API.
Steps:
These instances are created through data migration using Csi_item_instance_pub.Create_item_instance API.
1. First we are creating instances in 'Latest' status
2. Updating instance status to 'Expired' using update script.
Update Script:
UPDATE Csi.Csi_item_instances
SET Instance_status_id = 1 --EXPIRED
WHERE 1 = 1
AND Instance_id = 30652
Please suggest.