[xwiki-users] Hibernate query using in a database list property of some class

Hello everybody! I have my class, in my class I have property with type = Database List. In this property I need to write hibernate query with filter by space, but not predifined space - I need to setup filter which will be compare space of a active document (which I will edit) with space of a hibernate query result document. How I can do it? Without this filter by space my query look like this and working without problems: select otherprop.value from XWikiDocument doc, BaseObject obj, StringProperty prop, StringProperty otherprop where doc.fullName=obj.name and obj.className='MySpace.MyClass' and obj.name not like '%ClassTemplate' and prop.id.id=obj.id and prop.id.name='Prop1' and prop.value='MyValue' and obj.id=otherprop.id.id and otherprop.id.name='Prop2' order by prop.value asc, otherprop.value asc Thanks beforehand! Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/Hibernate-query-using-in-a-database-list-… Sent from the XWiki- Users mailing list archive at Nabble.com.