All ratings entries of the entire portal are included when exporting any specific site

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP FP15, 7.0.X EE, Master
• Fix Version/s: 7.0.0 DXP FP21, 7.0.0 DXP SP4, 7.0.X EE, 7.1.X, Master
• Component/s: Content Publishing > Export/Import
• Labels:
  • ee-ts
  • liferay-digital-enterprise-70-sp4
  • liferay-fixpack-de-21-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/49461

1. Create 10000 blogs and ratings entries by running the attached Groovy script
2. Create a new site "testsite"
3. Manually export the completely empty testsite with default options

Result: The export of the empty site takes about 4 minutes (depending on your machine's resources) because all the 10000 ratings will be exported also (the blog entries will not).

The reason is that the RatingsEntry model does not have a groupId, and therefore PageRatingsPortletDataHandler will not be able filter them by the exported site's groupId when fetching the ones to export. Only the entities that they are rating have a groupId so we have to filter for that.

Note: This anomaly affects site creation from site template also. E.g. creating a new site from the Intranet Site template takes about the same amount of time because of this unnecessary export and import, which also doesn't make any sense.