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
> Facebook
> email
>
>
>
> ___
> 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] Skins - Fix Nav Menus when scrooling page content
Hello. For the top menu, I think you should look at: http://getbootstrap.com/components/#navbar-fixed-top Example: https://jsfiddle.net/5hspvk08/ For the panels, however, it's more complex. I hope it helps, 2016-09-27 17:09 GMT+02:00 Ramon Gomes Brandao < ramon.bran...@planejamento.gov.br>: > Hi XWiki Team, > > I'm trying to design a new skin based on flaming to attend our company's > use cases (with XE 8.x) and we were required to fix the top menu divs (for > instance, the menuview div and the headerglobal div), as well as, if > possible, side panels, while scrooling the page content. The side panels > div shoud also be scroolabe, when the elements overflow the viewport. > > I could not achieve any success overriding some flamingo's CSS and trying > to fix elements with position CSS statement. How is the best way to achieve > that using a new skin approach? I won't also forget to be responsible for > small screens, so fixing side panels and top menu is not a good idea. How > is the best way to deal with this? > > Best Regards, > > > RAMON BRANDÃO > > ___ > 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] Task Manager Extension
Thanks Vincent, I opted for the subwiki in the end. But this has now caused a new problem. Task Manager itself works fine but the Kanban Board Macro although shows the information isn't pulling through global users correctly so it is showing a ? At the end of the person's name as no page exists for it. Any further ideas on how I can fix that? From: Vincent Massol Sent: Friday, 23 September, 07:59 Subject: Re: [xwiki-users] Task Manager Extension To: XWiki Users Hi Stev, > On 23 Sep 2016, at 08:43, Stev Williams wrote: > > Hi, > Is it possible to setup multiple Task Managers?For our Wiki we have various > teams that use it and each would like its own task manager. I have had a > look around and can't see any option to do this within the extension itself > but wondered if I am missing something. I don’t know the app but I’ve read its doc quickly. I can think of 2 ideas for you: 1) The app supports the notion of multiple project. You could use one (or several) project per team 2) You could have one subwiki per team and then each team can install whatever app they want in their subwiki. You can even provide template subwikis to make it easy to create new wikis with the apps already installed. See http://extensions.xwiki.org/xwiki/bin/view/Extension/Wiki+Application Thanks -Vincent > Regards > ___ 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
[xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1
Hi All, I am currently using XWiki 4.2 war deployed on apache-tomcat and also using MySQL DB. I am using XWiki clustered 2 based on network events distribution. I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm mode") which allows us to have several wikis running on the same XWiki instance (i.e. in the same JVM). I also configured Scheduled jobs to empty trash and getting it triggered via cron expression. I am facing serious performance issue as Xwiki application has become very slow and frequently results in timeout. To resolve the performance issue I would like to migrate my XWiki application from version 4.2 to 8.2.1. Is it a good decision? If now which version can be relatively cater more performance? Also if anyone can share the high level steps which must be followed while migration, would be great help. Thanks & Regards, Piyush ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1
Hi All, I am currently using XWiki 4.2 war deployed on apache-tomcat and also using MySQL DB. I am using XWiki clustered 2 based on network events distribution. I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm mode") which allows us to have several wikis running on the same XWiki instance (i.e. in the same JVM). I also configured Scheduled jobs to empty trash and getting it triggered via cron expression. I am facing serious performance issue as Xwiki application has become very slow and frequently results in timeout. To resolve the performance issue I would like to migrate my XWiki application from version 4.2 to 8.2.1. Is it a good decision? If now which version can be relatively cater more performance? Also if anyone can share the high level steps which must be followed while migration, would be great help. Thanks & Regards, Piyush ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1
> On 28 Sep 2016, at 15:29, Vincent Massol wrote: > > See http://markmail.org/message/wekcctzz2zdoffit > > Please don’t send the same mail several times… :) You already sent it 3 times… -Vincent > Thanks > -Vincent > >> On 28 Sep 2016, at 15:26, Kumar, Piyush wrote: >> >> Hi All, >> >> I am currently using XWiki 4.2 war deployed on apache-tomcat and also using >> MySQL DB. I am using XWiki clustered 2 based on network events >> distribution. I am also using A multi-tenant setup ( "virtual mode", >> "multi-wiki" or "farm mode") which allows us to have several wikis running >> on the same XWiki instance (i.e. in the same JVM). I also configured >> Scheduled jobs to empty trash and getting it triggered via cron expression. >> >> I am facing serious performance issue as Xwiki application has become very >> slow and frequently results in timeout. >> >> To resolve the performance issue I would like to migrate my XWiki >> application from version 4.2 to 8.2.1. >> >> Is it a good decision? If now which version can be relatively cater more >> performance? Also if anyone can share the high level steps which must be >> followed while migration, would be great help. >> >> Thanks & Regards, >> Piyush ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1
See http://markmail.org/message/wekcctzz2zdoffit Please don’t send the same mail several times… :) Thanks -Vincent > On 28 Sep 2016, at 15:26, Kumar, Piyush wrote: > > Hi All, > > I am currently using XWiki 4.2 war deployed on apache-tomcat and also using > MySQL DB. I am using XWiki clustered 2 based on network events distribution. > I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm > mode") which allows us to have several wikis running on the same XWiki > instance (i.e. in the same JVM). I also configured Scheduled jobs to empty > trash and getting it triggered via cron expression. > > I am facing serious performance issue as Xwiki application has become very > slow and frequently results in timeout. > > To resolve the performance issue I would like to migrate my XWiki application > from version 4.2 to 8.2.1. > > Is it a good decision? If now which version can be relatively cater more > performance? Also if anyone can share the high level steps which must be > followed while migration, would be great help. > > Thanks & Regards, > Piyush ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1
Hi, > On 28 Sep 2016, at 15:31, Kumar, Piyush wrote: > > > Hi Vincent, > > I apologize for sending it three times. I thought this message has not > delivered as on delivery I was expecting that it will come in my inbox as > well. > Will take care of this.:) ok! Have you seen the answer that I had sent back then: http://markmail.org/message/wekcctzz2zdoffit ? Thanks -Vincent > > Thanks & Regards, > Piyush > -Original Message- > From: users [mailto:users-boun...@xwiki.org] On Behalf Of Vincent Massol > Sent: Wednesday, September 28, 2016 7:00 PM > To: XWiki Users > Subject: Re: [xwiki-users] I would like to migrate my xwiki application from > 4.2 to 8.2.1 > > >> On 28 Sep 2016, at 15:29, Vincent Massol wrote: >> >> See http://markmail.org/message/wekcctzz2zdoffit >> >> Please don’t send the same mail several times… :) > > You already sent it 3 times… > > -Vincent > >> Thanks >> -Vincent >> >>> On 28 Sep 2016, at 15:26, Kumar, Piyush wrote: >>> >>> Hi All, >>> >>> I am currently using XWiki 4.2 war deployed on apache-tomcat and also >>> using MySQL DB. I am using XWiki clustered 2 based on network events >>> distribution. I am also using A multi-tenant setup ( "virtual mode", >>> "multi-wiki" or "farm mode") which allows us to have several wikis running >>> on the same XWiki instance (i.e. in the same JVM). I also configured >>> Scheduled jobs to empty trash and getting it triggered via cron expression. >>> >>> I am facing serious performance issue as Xwiki application has become very >>> slow and frequently results in timeout. >>> >>> To resolve the performance issue I would like to migrate my XWiki >>> application from version 4.2 to 8.2.1. >>> >>> Is it a good decision? If now which version can be relatively cater more >>> performance? Also if anyone can share the high level steps which must be >>> followed while migration, would be great help. >>> >>> Thanks & Regards, >>> Piyush > > ___ > 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
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
Facebook
email
From: users on behalf of Guillaume Delhumeau
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 :
> 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
> Facebook
> email
>
>
>
> ___
> 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] I would like to migrate my xwiki application from 4.2 to 8.2.1
Hi Vincent, Regarding DB indexing I would like to tell you that I already created below indexes as per the page http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration to deal with performance but could not get any benefit. Sice we are having 4.2 version at production, we created below mentioned indexes in our MySQL DB. Indexes for XWiki Enterprise versions after 3.2 create index xwl_value on xwikilargestrings (xwl_value(50)); create index xwd_parent on xwikidoc (xwd_parent(50)); create index xwd_class_xml on xwikidoc (xwd_class_xml(20)); create index xws_number on xwikistatsdoc (XWS_NUMBER); create index xws_classname on xwikistatsdoc (XWS_CLASSNAME); create index xwr_number on xwikistatsreferer (XWR_NUMBER); create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME); create index xwr_referer on xwikistatsreferer (XWR_REFERER(50)); create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255)); create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255)); create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME); create index xwv_number on xwikistatsvisit (XWV_NUMBER); create index ase_requestid on activitystream_events (ase_requestid(200)); create index ase_page_date on activitystream_events (ase_page, ase_date); create index xda_docid1 on xwikiattrecyclebin (xda_docid); create index ase_param1 on activitystream_events (ase_param1(200)); create index ase_param2 on activitystream_events (ase_param2(200)); create index ase_param3 on activitystream_events (ase_param3(200)); create index ase_param4 on activitystream_events (ase_param4(200)); create index ase_param5 on activitystream_events (ase_param5(200)); Thanks & Regards, Piyush -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Vincent Massol Sent: Friday, September 23, 2016 6:33 PM To: XWiki Users Subject: Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1 > On 23 Sep 2016, at 14:49, Kumar, Piyush wrote: > > Hi All, > > I am currently using XWiki 4.2 war deployed on apache-tomcat and also using > MySQL DB. I am using XWiki clustered 2 based on network events distribution. > I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm > mode") which allows us to have several wikis running on the same XWiki > instance (i.e. in the same JVM). I also configured Scheduled jobs to empty > trash and getting it triggered via cron expression. > > I am facing serious performance issue as Xwiki application has become very > slow and frequently results in timeout. > > To resolve the performance issue I would like to migrate my XWiki application > from version 4.2 to 8.2.1. > > Is it a good decision? It is. Actually what you’ve done (stay very long on a very old version is not such a good idea ;) (will make the upgrade a lot more complex). Since you’re using a very old version you may want to export your data, install XWiki 8.2.1 and import your data. However see the limitations at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiExportfeature > If now which version can be relatively cater more performance? Also if anyone > can share the high level steps which must be followed while migration, would > be great help. Re performance you can get good perf in 4.2 too. If I had to guess I’d say you’re missing indexes in the DB, see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances Thanks -Vincent PS: Since this is a complex operation, I’d highly suggest that you hire some xwiki experts. There are companies offering such expertise and that are sponsoring the development of the xwiki project. See http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport > Thanks & Regards, > Piyush ___ 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
[xwiki-users] Program = Admin Expected Behavior?
I was testing with a few user accounts and found that users in a specific group had admin rights even though they weren't in the XWikiAdminGroup and the group they were in did not have Admin rights checked. After some trial and error I found that removing the Program right removed Admin rights as well. Is this the expected behavior? I just upgraded to 8.2.1, but this might have been the case before and I just hadn't noticed. Thanks, Jared -- View this message in context: http://xwiki.475771.n2.nabble.com/Program-Admin-Expected-Behavior-tp7601420.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Deleted Groups Reappear
I'm in the process of setting up LDAP authentication. In the process I created a few groups that are no longer needed. The groups disappear from the list when I click the red X, but they always reappear the next time I view the list of groups. Is there something else I should be doing to delete groups? Thanks, Jared -- View this message in context: http://xwiki.475771.n2.nabble.com/Deleted-Groups-Reappear-tp7601421.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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 :
> 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
> Facebook
> email
>
>
>
>
> From: users 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 :
>
> > 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
> > Facebook
> > email
> >
> >
> >
> > ___
> > 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
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 :
>
>> 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
>> Facebook
>> email
>>
>>
>>
>>
>> From: users 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 :
>>
>> > 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
>> > Facebook
>> > email
>> >
>> >
>> >
>> > ___
>> > 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
