16 Jan
2006
16 Jan
'06
1:14 p.m.
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
16 Jan
16 Jan
4:25 p.m.
New subject: [xwiki-users] Hibernation Query for Database List
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
8:49 p.m.
New subject: [xwiki-users] Hibernation Query for Database List
Hi,
wow, it works! I had to change the ClassSheet to use
#set($obj = $doc.getObject("XWiki.TodoClass",0))
and
$doc.display($prop.getName(),"edit",$obj)
instead of just
$doc.display($prop.getName())
Now one last question:
Can I select multiple columns too? I would love to have the
first_name and last_name in my drop-down.
Thanks a lot!
Sascha
jeremi joslin wrote:
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
------------------------------------------------------------------------
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
6915
days inactive
6915
days old
2 comments
2 participants
participants (2)
-
jeremi joslin -
Sascha Österle