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:
                Annie Wu
                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