For list of Users, it's the fullname of the document holding the user,
example: XWiki:gdelhumeau.
For a database list, it depends on what you have put in the class. You
haven't given enough information about the "research" field. Could you
describe it a bit more?
2016-09-28 16:23 GMT+02:00 Gerritjan Koekkoek <gerrit...@cdlsworld.org>:
> Thanks, code checked, made some improvements.
>
> But the query should recognize that both class attributes are of type
> DBLIST.
>
>
> the question is how I should specify the where clause:
>
>
> so
>
> where dblist_property1 = :bindvalue1 and dblist_property2 = :bindvalue2
>
>
> What should we put in our two bindvalue's ?
>
> a string: 'text'
>
> a array: ['text']
>
> a object {text}
>
>
> Gerritjan Koekkoek
> Vader van Rai Koekkoek (cdls) en voorzitter vereniging CdLS
> Visit our website<http://www.cdlsworld.org>
> Facebook<https://www.facebook.com/gerritjan.koekkoek>
> email<gerrit...@cdlsworld.org>
>
>
>
> ________________________________
> From: users <users-boun...@xwiki.org> on behalf of Guillaume Delhumeau <
> guillaume.delhum...@xwiki.com>
> Sent: 28 September 2016 12:12:16
> To: XWiki Users
> Subject: Re: [xwiki-users] XWQL datatype question
>
> Hi.
>
> Note that this line:
> #set( $qParticipations = "from doc.object('$participationClassName') as
> participation where doc.fullName <> 'waihonapediaResearchParticipat
> ionTemplate'
> and participation.research = :thisresearch" and participation.family =
> :thisUser)
>
> is invalid (you closed the " too soon). But I guess it's not your problem.
>
> Also, I really doubt that you have a page called
> 'waihonapediaResearchParticipationTemplate' (it's supposed to be a
> fullname).
>
> There is also invalid simple quotes (') in doc.object.
>
>
> So the correct query should be:
> #set( $qParticipations = "from doc.object(WaihonaCode.
> waihonapediaResearchParticipationClass) as participation where
> doc.fullName
> <> 'WaihonaCode.waihonapediaResearchParticipationTemplate' and
> participation.research = :thisresearch and participation.family =
> :thisUser")
>
> I hope it helps,
>
> 2016-09-27 14:03 GMT+02:00 Gerritjan Koekkoek <gerrit...@cdlsworld.org>:
>
> > Hi,
> >
> >
> > I have this class:
> >
> > #set( $participationClassName = "WaihonaCode.
> > waihonapediaResearchParticipationClass" )
> >
> >
> > Class properties
> >
> > researchparticipation.family (family: List of Users)
> >
> > researchparticipation.research (research: Database List)
> >
> > researchparticipation.participate (participate: Boolean)
> >
> > researchparticipation.datasend (datasend: Boolean)
> >
> >
> >
> > I have this XWQL:
> >
> >
> > #set( $qParticipations = "from doc.object('$participationClassName') as
> > participation where doc.fullName <> 'waihonapediaResearchParticipat
> ionTemplate'
> > and participation.research = :thisresearch" and participation.family =
> > :thisUser)
> >
> >
> > I'm getting velocity error:
> >
> > Caused by: org.hibernate.QueryException: could not resolve property:
> > research of: com.xpn.xwiki.objects.BaseObject [ select doc.fullName from
> > com.xpn.xwiki.doc.XWikiDocument as doc , com.xpn.xwiki.objects.
> BaseObject
> > as participation where
> >
> >
> > When doing similar on a class where class properties are of type string I
> > have no Issues?
> >
> > What should I do with these properties: List of Users (always only 1) and
> > Database List (always only 1)?
> >
> >
> > Gerritjan Koekkoek
> > Vader van Rai Koekkoek (cdls) en voorzitter vereniging CdLS
> > Visit our website<http://www.cdlsworld.org>
> > Facebook<https://www.facebook.com/gerritjan.koekkoek>
> > email<gerrit...@cdlsworld.org>
> >
> >
> >
> > _______________________________________________
> > users mailing list
> > users@xwiki.org
> > http://lists.xwiki.org/mailman/listinfo/users
> >
>
>
>
> --
> Guillaume Delhumeau (guillaume.delhum...@xwiki.com)
> Research & Development Engineer at XWiki SAS
> Committer on the XWiki.org project
> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
--
Guillaume Delhumeau (guillaume.delhum...@xwiki.com)
Research & Development Engineer at XWiki SAS
Committer on the XWiki.org project
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
