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 <[email protected]> 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