[xwiki-users] XWQL datatype question

List overview All Threads
Download

newer

older

[xwiki-users] Database indexes for...

[xwiki-users] Deleted Groups...

Gerritjan Koekkoek

27 Sep 2016 27 Sep '16

2:03 p.m.

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<gerritjan(a)cdlsworld.org>

Show replies by date

Guillaume Delhumeau

28 Sep 28 Sep

12:12 p.m.

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 <gerritjan(a)cdlsworld.org>rg>:

...

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<gerritjan(a)cdlsworld.org> _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Guillaume Delhumeau (guillaume.delhumeau(a)xwiki.com) Research & Development Engineer at XWiki SAS Committer on the XWiki.org project

Gerritjan Koekkoek

4:23 p.m.

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<gerritjan(a)cdlsworld.org> ________________________________ From: users <users-bounces(a)xwiki.org> on behalf of Guillaume Delhumeau <guillaume.delhumeau(a)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 <gerritjan(a)cdlsworld.org>rg>:

...

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<gerritjan(a)cdlsworld.org> _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Guillaume Delhumeau

5:31 p.m.

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 <gerritjan(a)cdlsworld.org>rg>:

...

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<gerritjan(a)cdlsworld.org> ________________________________ From: users <users-bounces(a)xwiki.org> on behalf of Guillaume Delhumeau < guillaume.delhumeau(a)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 <gerritjan(a)cdlsworld.org>rg>:

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<gerritjan(a)cdlsworld.org> _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- 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 _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Guillaume Delhumeau (guillaume.delhumeau(a)xwiki.com) Research & Development Engineer at XWiki SAS Committer on the XWiki.org project

Guillaume Delhumeau

5:34 p.m.

More over, it also depends on the field "Relational Storage". See, for example: https://www.xwiki.org/xwiki/bin/view/FAQ/HowToCreateAOneToManyRelationshipI… 2016-09-28 17:31 GMT+02:00 Guillaume Delhumeau < guillaume.delhumeau(a)xwiki.com>gt;:

...

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<gerritjan(a)cdlsworld.org> ________________________________ From: users <users-bounces(a)xwiki.org> on behalf of Guillaume Delhumeau < guillaume.delhumeau(a)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 <gerritjan(a)cdlsworld.org>rg>:

tionTemplate'

from

com.xpn.xwiki.doc.XWikiDocument as doc , com.xpn.xwiki.objects.BaseObje

as participation where When doing similar on a class where class properties are of type string

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<gerritjan(a)cdlsworld.org> _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Guillaume Delhumeau (guillaume.delhumeau(a)xwiki.com) Research & Development Engineer at XWiki SAS Committer on the XWiki.org project

2910

days inactive

2911

days old

xwiki-users@xwiki.org

Manage subscription

4 comments

2 participants

tags (0)

participants (2)

Gerritjan Koekkoek
Guillaume Delhumeau