The error comes from somewhere else in my class I think, as I took out
the prop2 condition things and it still does not work. Would be nice,
if you could tell me anyways, if the statement is correct for what I
plan to do.
Thanx
Cheers
Sebastian
On Tue, Feb 17, 2009 at 12:29 PM, Sebastian Kannengiesser
<sebastian.kannengiesser(a)gmail.com> wrote:
Hi guys,
what is wrong here:
--snip--
select prop.value from BaseObject as obj, StringProperty as prop,
StringProperty as prop2, where
obj.className='XWiki.ServicesReviewerClass' and prop.id.id=obj.id and
prop2.id.id=obj.id and prop.id.name='name' and
prop2.id.name='externintern' and prop2.value='intern' order by
prop.value
--snap--
I'm using this for a database list field in a class. I want to list
all objects by the name property, but only those, where property
"externintern" is set to extern (static list).
Many thanx in advance.
Cheers
Sebastian