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

SF rule to require adding the companyId field to new tables unless is a control table

    Details

      Description

      Supporting saas requires that we have to separate data (physically) based on the companyId.

      Originally we thought about modifying the Service Builder to achieve it (see LPS-103481) but we don't want to affect custom developments for now.

      For that reason, we are going to create a SF rule which will require the use of the companyId column for new tables unless is a control table (a table is considered as "control table" when it stores data a portal level, it doesn't store data specifically for a particular instance (company), for example, Release, ResourceAction or Counter). This will be the logic of the SF rule:

      1. Detect new tables in service.xml files
      2. Require to add the companyId field unless it is a control table

      We should have a way to bypass this control for new control tables (a property or something like that)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alberto.chaparro Alberto Chaparro
              Reporter:
              alberto.chaparro Alberto Chaparro
              Engineering Assignee:
              SE Support
              Recent user:
              Kiyoshi Lee
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  7.3.0 CE GA1
                  Master