More over, it also depends on the field "Relational Storage". See, for example: https://www.xwiki.org/xwiki/bin/view/FAQ/HowToCreateAOneToManyRelationshipInXWiki
2016-09-28 17:31 GMT+02:00 Guillaume Delhumeau < guillaume.delhum...@xwiki.com>: > 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 <> 'waihonapediaResearchParticipa >> tionTemplate' >> 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 <> 'waihonapediaResearchParticipa >> tionTemplate' >> > 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.BaseObje >> ct >> > 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 > -- 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