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
