Changes for page HQL Scripting Examples in Velocity
Last modified by Manuel Leduc on 2023/02/02
From version 1.29
edited by Jean-Vincent Drean
on 2007/10/09
on 2007/10/09
Change comment:
There is no comment for this version
To version 1.30
edited by Jean-Vincent Drean
on 2007/10/09
on 2007/10/09
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -145,8 +145,9 @@ 145 145 #displayQuery($hql true) 146 146 147 147 <br/> 148 -1.1.1 Getting objects' properties 149 -#set($hql="select o bj.name,prop.valuefromBaseObject obj, StringProperty prop where obj.className='XWiki.XWikiUsers' and prop.id.id=obj.id and prop.name='first_name'")148 +1.1.1 Getting documents where objects' properties equals some value 149 +#set($hql="select doc.fullName from XWikiDocument doc, BaseObject obj, StringProperty prop where doc.fullName=obj.name and obj.className='XWiki.XWikiUsers' and prop.id.id=obj.id and prop.name='first_name' and prop.value='Jean-Vincent'") 150 150 #displayQuery($hql true) 151 151 152 152 153 +
