Re: [xwiki-users] XWQL datatype question

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&lt;gerritjan(a)cdlsworld.org&gt; ________________________________ From: users &lt;users-bounces(a)xwiki.org&gt; on behalf of Guillaume Delhumeau &lt;guillaume.delhumeau(a)xwiki.com&gt; 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 <> 'waihonapediaResearchParticipationTemplate' 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 &lt;gerritjan(a)cdlsworld.org&gt;rg>: -- Guillaume Delhumeau (guillaume.delhumeau(a)xwiki.com) Research & Development Engineer at XWiki SAS Committer on the XWiki.org project _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users