org.opencms.db.mssql.query.properties Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of opencms-test Show documentation
Show all versions of opencms-test Show documentation
OpenCms is an enterprise-ready, easy to use website content management system based on Java and XML technology. Offering a complete set of features, OpenCms helps content managers worldwide to create and maintain beautiful websites fast and efficiently.
#
# The pattern _${PROJECT}_ in table names is replaced by the SqlManager with
# "_ONLINE_" or "_OFFLINE_" to choose the right database tables for
# SQL queries that are project dependent!
#
# MS SQL specific because of the row limitation
C_MSSQL_PROJECTS_READLAST_HISTORY=\
SELECT TOP 300 \
PUBLISH_TAG,\
PROJECT_ID,\
PROJECT_NAME,\
PROJECT_PUBLISHDATE,\
PROJECT_PUBLISHED_BY,\
USER_ID,\
GROUP_ID,\
MANAGERGROUP_ID,\
PROJECT_DESCRIPTION,\
DATE_CREATED,\
PROJECT_TYPE,\
PROJECT_OU \
FROM \
CMS_HISTORY_PROJECTS \
ORDER BY \
PUBLISH_TAG DESC
# MS SQL specific because of missing concat function: use concat operator +
C_READ_RESOURCE_OUS=\
SELECT DISTINCT \
${C_RELATIONS_SELECT_ATTRIBS} \
FROM \
CMS_${PROJECT}_RESOURCE_RELATIONS \
WHERE \
CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TYPE = ? \
AND ? LIKE (CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH + '%')
© 2015 - 2024 Weber Informatics LLC | Privacy Policy