On 1/16/06, Sascha Österle <sascha.oe(a)aon.at> wrote:
Hi,
I have a class with a database list property that should list all
available users but I got no idea how the hibernation query should look.
Thanks!
Sascha
Hi,
select prop.value from BaseObject as obj, StringProperty as prop where
obj.className='XWiki.CompanyClass' and prop.id.id = obj.id and
prop.id.name='name' order by prop.value
replace "XWiki.CompanyClass" by your the className of the class who
contains the list of users and 'name' by the column name
Jérémi
--
Blog:
http://www.jeremi.info
LinkedIn:
https://www.linkedin.com/profile?viewProfile=&key=1437724
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : jeremi23(a)gmail.com