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.kannengies...@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
>
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to