Re: [xwiki-users] Hibernation Query for Database List

On 1/16/06, Sascha Österle <[email protected]> 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 : [email protected]