Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1305)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1366)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:90)
... 147 more
Caused by: org.hibernate.QueryException: could not resolve property: street of:
com.xpn.xwiki.objects.BaseObject [ select doc.fullName from
com.xpn.xwiki.doc.XWikiDocument as doc , com.xpn.xwiki.objects.BaseObject as ttt where (
ttt.street = 'Burchtenlaan 97' ) and doc.fullName=ttt.name and
ttt.className='CdlsatdCode.CdLS_ATD_UserProfileClass' ]
I have XWQL statement that throws this error?
But double checking I can not find why it states that 'street' is a property it
can not solve?
#set($supportgroupQry = "from doc.object(CdlsatdCode.CdLS_ATD_UserProfileClass) as
ttt where ttt.street = 'Burchtenlaan 97'")
$services.query.xwql($supportgroupQry).execute()
The class:
CdLS_ATD_UserProfileClass
Class properties
Street Address (street: String)
City (city: String)
State (state: String)
Postal Code (postalCode: String)
Country (country: String)
Telephone (telephone: String)
cdlsPersonName (cdlsPersonName: String)
Date of Birth (cdlspersonDOB: Date)
Height (cdlspersonHeight: String)
measureHeight (measureHeight: Static List)
Weight (cdlspersonWeight: String)
measureWeight (measureWeight: Static List)
Current Medication (currentMedication: TextArea)
Your relationship with this person (cdlspersonRelation: String)
contextUsr (contextUsr: String)
Allowance for visibility of profile (visible: Boolean)
Open to be contacted by other members (contact: Boolean)
supportGroup (supportGroup: Database List)
gender (gender: Static List)
socialStatus (socialStatus: String)
cdlsPersonAvatar (avatar: String)
Gerritjan Koekkoek