Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-52524

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

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              jorge.diaz Jorge Diaz
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Packages

                  Version Package