Re: [xwiki-users] XWQL datatype question
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
Re: [xwiki-users] XWQL datatype question
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
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<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 <> '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 <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 <> > 'waihonapediaResearchParticipationTemplate' > 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
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: > 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 <> > 'waihonapediaResearchParticipationTemplate' > 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 > > > > ___ > 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
[xwiki-users] XWQL datatype question
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 <> 'waihonapediaResearchParticipationTemplate' 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___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users