BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Mazi
Quartz | Level 8

Good day, 

I had a question relating to SAS VI 10.8 on Viya 3.5.

 

Is it possible to delete an object (internal case) that has a relationship with other entities? 

The reason we want to do this is because we have a case that is "duplicated" and was accidentally logged twice. I tried adding the delete toolbar object, but received an error stating that this object could not be deleted as it has relationships with other entities.

 

Thanks,

Mazi

1 ACCEPTED SOLUTION

Accepted Solutions
susantrueman
SAS Employee

Hi Mazi, 

 

Yes, you can delete an object (assuming you have delete permissions) so long as you first delete any relationships to other objects. You can delete relationships from the Relationships side panel which is opened from the "Relationships" toolbar button on an object. 

 

You need to make sure the user has the "delete relationships between objects" capability and both the "Delete" button and the "Relationships" button are on the toolbar. 

 

To delete the relationships: 

  1. Open the object (i.e. Case-1234)
  2. Select the Relationships toolbar button to open Relationships panel 
  3. Select the relationship you want to delete and from the overflow menu select "Delete Relationship" 
  4. You will be prompted to confirm before deleting.

You should then be able to delete the object.

 

Care should be taken when deleting relationships and objects as they are deleted completely - they are not archived or recoverable. 

 

Another option could be to include a status field on the object and relationship that is updated to say "duplicate" or similar if you did not want to delete but wanted to show these were no longer required or closed. If you still wanted to delete these objects you could then have administrators or other elevated users check for these "flagged" relationships and objects and perform a deletion (something to consider if you don't want to grant "delete" capabilities to other users. 

 

Thanks

Susan

 

 

View solution in original post

2 REPLIES 2
susantrueman
SAS Employee

Hi Mazi, 

 

Yes, you can delete an object (assuming you have delete permissions) so long as you first delete any relationships to other objects. You can delete relationships from the Relationships side panel which is opened from the "Relationships" toolbar button on an object. 

 

You need to make sure the user has the "delete relationships between objects" capability and both the "Delete" button and the "Relationships" button are on the toolbar. 

 

To delete the relationships: 

  1. Open the object (i.e. Case-1234)
  2. Select the Relationships toolbar button to open Relationships panel 
  3. Select the relationship you want to delete and from the overflow menu select "Delete Relationship" 
  4. You will be prompted to confirm before deleting.

You should then be able to delete the object.

 

Care should be taken when deleting relationships and objects as they are deleted completely - they are not archived or recoverable. 

 

Another option could be to include a status field on the object and relationship that is updated to say "duplicate" or similar if you did not want to delete but wanted to show these were no longer required or closed. If you still wanted to delete these objects you could then have administrators or other elevated users check for these "flagged" relationships and objects and perform a deletion (something to consider if you don't want to grant "delete" capabilities to other users. 

 

Thanks

Susan

 

 

Mazi
Quartz | Level 8

@susantrueman

 

Thank you very much for your help with this. It is truly appreciated.

Discussion stats
  • 2 replies
  • 646 views
  • 0 likes
  • 2 in conversation