DXP70-propertiesStoredInDatabase.groovy

import javax.portlet.PortletPreferences;
import com.liferay.portal.kernel.util.PortalUtil;
import com.liferay.portal.kernel.util.PortletKeys;
import com.liferay.portal.kernel.service.PortalPreferencesLocalServiceUtil;


companyId = PortalUtil.getDefaultCompanyId()


PortletPreferences portalPreferences = PortalPreferencesLocalServiceUtil.getPreferences(PortletKeys.PREFS_OWNER_ID_DEFAULT, PortletKeys.PREFS_OWNER_TYPE_COMPANY);
PortletPreferences companyPreferences = PortalPreferencesLocalServiceUtil.getPreferences(companyId, PortletKeys.PREFS_OWNER_TYPE_COMPANY);
Map<String, String[]> preferencesMap = portalPreferences.getMap();
preferencesMap.putAll(companyPreferences.getMap())

preferencesMap.each{ key, value -> 
    println key + ": " + value
    println " -------------------------------------------------- "
}