There are objects, like ADT templates, that can be deleted when are used by a portlet, so data inconsistence is created

• Type: Feature Request
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Master
• Fix Version/s: None
• Component/s: Widget Templates, ~[Archived] WCM
• Labels:
  • SME-should-7.2
  • ee-nf

There are objects, like ADT templates, that can be deleted even when they are being used by a portlet,, so data inconsistence is created.

Steps to reproduce for ADT templates: See LPS-52320

So for every object that a reference is stored at portletpreferences, a validation must be done before execute the deletion operation to avoid inconsistencies.

For example, for ADT templates we can check it at deletion time, executing following SQL

select count(*) from portletpreferences 
where portletid like '101%' and 
preferences like '%ddmTemplate_133655e8-6afd-5d8a-524e-070b47929619%'

This SQL perhaps is a bit is expensive because of "like" commands, perhaps a new column or table with references must be stored to allow a quicker check at deletion time.