#1 Bug in JPQL for method CmsObject.readResourcesWithProperty()

[roman jagger]

There is a bug in QL in org/opencms/db/jpa/query.properties,
exactly:
C_RESOURCES_GET_RESOURCE_WITH_PROPERTYDEF_VALUE2=\
SELECT DISTINCT \
${C_RESOURCES_SELECT_ATTRIBS} \
FROM \
CmsDAO${PROJECT}Properties T_CmsDAO${PROJECT}Properties , \
CmsDAO${PROJECT}Resources T_CmsDAO${PROJECT}Resources , \
CmsDAO${PROJECT}Structure T_CmsDAO${PROJECT}Structure \
WHERE \
T_CmsDAO${PROJECT}Properties.m_propertyDefId = ? \
AND T_CmsDAO${PROJECT}Properties.m_propertyMappingId = T_CmsDAO${PROJECT}Structure.m_structureId \
AND T_CmsDAO${PROJECT}Structure.m_resourceId = T_CmsDAO${PROJECT}Resources.m_resourceId \
AND T_CmsDAO${PROJECT}Structure.m_resourcePath LIKE ? \
AND T_CmsDAO${PROJECT}Properties.m_propertyValue LIKE ? \
ORDER BY RESOURCE_PATH DESC

When using method:
CmsObject.readResourcesWithProperty(folderName, PROPERTY_NAME, PROPERTY_VALUE), there is an exception on using
ORDER BY RESOURCE_PATH DESC.

there should be:
ORDER BY T_CmsDAO${PROJECT}Structure.m_resourcePath DESC
instead.

[roman jagger]

This bug is in both versions- 7.0.5 and 7.5.0

[Georgi Naplatanov]

Hello jagger79. Sorry for the late response. This bug is fixed in latest build of 7.5.3.

binary - http://os.oles.biz/opencms/jpa-driver/opencms_7.5.3-jpa-2010-09-30.zip
SVN - https://opencms-jpa.oles.biz/opencmsjpa/branches/7.5.3/

Best regards
Georgi