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 _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users