Different between Restrict Delete and Cascade Delete in List

 

 

Restrict Delete:

It Means that users cannot delete the data in Batch list if the data is referenced.
They can only delete the data in the parent list only if the referenced data in the child list is completely deleted. So, if we want to delete an item in Batch we have to delete the Product list data that is using ‘Batch′.
SharePoint will give the following error if we try to delete until all references are deleted.

Cascade delete:

 It means that users can delete the data in Batch list though the data is referenced.
But, once we delete the item in the Batch list all the items that referred in the Product list will also be deleted.
While deleting it will give popup message which list is referencing its data and that data will also be deleted as in the following image

 

Comments

Post a Comment

Popular posts from this blog

Search Service Application Error in SP2013

Image
Search Service Application Error Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException: Windows NT user or group ‘SP\administrator’ not found. Check the name again. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean retu...
Read more

Errors While Importing Site Collection in SharePoint 2013/2010

Image
Actually we want delete some sub-sites from production. Which were create by custom template (Custom Site Template). We need to take all sub-sites backup separable. What we did, Just Exported one sub-site for testing purpose and trying imported on Staging farm. We faced below issues. Importing Sub-site: Import-SPWeb http://abc1:5555/Arabic/Dept/Depts/cc1 -Path "D:\cc1\cc1.cmp" -UpdateVersions Overwrite -force 1.      Import-SPWeb : Cannot find an SPWeb object with Id or Url : http://abc:5555/Arabic/depts/depts/cc1 Here problem clearly say, No Url found. Try to create new sub-site with Custom site template.Still facing problem try to reset IIS(iisreset) and create sub-site. 2.      Import-SPWeb: Cannot import site. The exported site is based on the template DEPARTMENTS#0 but the destination site is based on the template CMSPUBLISHING#0. You can import sites only into sites that are based on same template as the expor...
Read more

Deleting Multiple Sub-sites within Site using PowerShell

Deleting Multiple Sub-sites within Site using PowerShell. function RemoveSPWebRecursively(     [Microsoft.SharePoint.SPWeb] $web) {     Write-Debug "Removing site ($($web.Url))..."         $subwebs = $web.GetSubwebsForCurrentUser()         foreach($subweb in $subwebs)     {         RemoveSPWebRecursively($subweb)         $subweb.Dispose()     }         $DebugPreference = "SilentlyContinue"     Remove-SPWeb $web -Confirm:$false     $DebugPreference = "Continue" } $DebugPreference = "SilentlyContinue" $web = Get-SPWeb "http://dept-sp10-dev/Arabic/dept/dept/cdd" $DebugPreference = "Continue" If ($web -ne $null) {     RemoveSPWebRecursively $web     $web.Dispose() }
Read more