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