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 > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
