#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