[xwiki-users] XWQL query: Grouping Date properties by year ?

2015-09-23 Thread Sylvain MARIE
Hello,

The following query counts documents by publication date.
{{velocity}}
## Count all publication dates
#set($results=$services.query.xwql("select guide.DocumentDate, 
count(guide.DocumentDate) from Document doc, doc.object(BIMGuides.GuideClass) 
as guide group by guide.DocumentDate order by guide.DocumentDate").execute())
PublicationDate,Count
#foreach($result in $results)
#set($resDate = $result.get(0))
#set($resString = $resDate.toString().substring(0, 10))
$resString,$result.get(1)
#end
{{/velocity}}

I would like to regroup publication dates by year (getting « 2014,3 » when 2 
documents are published in Jan2014 and 1 in Oct2014) instead of getting all 
single dates.

Any idea ?

Thank you in advance!
Sylvain

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] Displaying Database List Properties as links to XWiki pages ?

2015-06-26 Thread Sylvain MARIE
Hello all,

I have a Database List which items are XWiki pages. Is there a way to make 
these items displayed as links so that one can access the related page by 
clicking on it?
Thanks in advance,
Sylvain 
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] Fetching some external XML resource and using it in a XWiki page?

2015-03-06 Thread Sylvain MARIE

Hello,

(warning n00b question ahead)
I would like to fetch external data, in xml (say for example 
https://raw.githubusercontent.com/xwiki/xwiki-commons/master/pom.xml) and use 
it in a XWiki page : filter tokens, display node contents, etc. At this stage I 
don’t envision populating a custom class.
Would you guys have pointers/examples of such xwiki page?
Thank you in advance!
Sylvain


___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] GA JSX not loaded anymore after 4.0--6.0.1 migration

2014-07-03 Thread Sylvain MARIE
Hello,

After migrating the database content of XWiki 4.0 into a new XWiki 6.0.1 
engine, the GA tracking JSX is no longer loaded in the XWiki pages :-(
I checked :
. 
http://bimguides.vtreem.com/bin/admin/XWiki/XWikiPreferences?section=analytics 
reports Google Analytics™ is running  with the proper GA ID
. on 
http://bimguides.vtreem.com/bin/edit/XWiki/GoogleAnalyticsCode?editor=object 
the following attributes are set:
Use this extension « Always on this wiki »
Parse content: yes
caching: long (also tried default)
Still, the Google Analytics debugger extension reports that the GA JS code is 
not fetched by the XWiki page (and indeed, there is no GA script in the page 
html source).

Does anyone know if the JSX mechanics has changed between 4.0 and 6.0.1 ? (I 
may have overwritten working code with outdated code when I used my 4.0 
mysqldump result with the fresh 6.0.1 WAR ?)

Thanks for your help!
Sylvain


Sylvain MARIE
VTREEM.com

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] GA JSX not loaded anymore after 4.0--6.0.1 migration

2014-07-03 Thread Sylvain MARIE

Hi Eduard,

Good catch !!
Forcing my user to have programming rights and re-saving the 
GoogleAnalyticsCode page did the trick. Many thanks !
I don’t know if a warning could be issued when a JSX is edited by a user 
without PR rights ? It could definitely help detecting such problems.
Anyway, thanks for your speedy and spot-on answer :-)
Sylvain

Sylvain MARIE
VTREEM.com

Le 3 juil. 2014 à 14:19, Eduard Moraru enygma2...@gmail.com a écrit :

 Hi Sylvain,
 
 Just a wild guess here, but for Always on this wiki options to work, the
 page needs to be saved with programming rights (so by a user that has PR).
 Maybe something happened during the migration and the page got saved by a
 user not having PR.
 
 Try to save the XWiki/GoogleAnalyticsCode
 http://bimguides.vtreem.com/bin/edit/XWiki/GoogleAnalyticsCode?editor=object
 page with the XWiki.Admin user, or any user having PR rights. This should
 properly register the JSX.
 
 Hope this helps,
 Eduard
 
 
 http://bimguides.vtreem.com/bin/edit/XWiki/GoogleAnalyticsCode?editor=object
 
 
 On Thu, Jul 3, 2014 at 2:26 PM, Sylvain MARIE sylvain.ma...@vtreem.com
 wrote:
 
 Hello,
 
 After migrating the database content of XWiki 4.0 into a new XWiki 6.0.1
 engine, the GA tracking JSX is no longer loaded in the XWiki pages :-(
 I checked :
 .
 http://bimguides.vtreem.com/bin/admin/XWiki/XWikiPreferences?section=analytics
 reports Google Analytics™ is running  with the proper GA ID
 . on
 http://bimguides.vtreem.com/bin/edit/XWiki/GoogleAnalyticsCode?editor=object
 the following attributes are set:
Use this extension « Always on this wiki »
Parse content: yes
caching: long (also tried default)
 Still, the Google Analytics debugger extension reports that the GA JS code
 is not fetched by the XWiki page (and indeed, there is no GA script in the
 page html source).
 
 Does anyone know if the JSX mechanics has changed between 4.0 and 6.0.1 ?
 (I may have overwritten working code with outdated code when I used my 4.0
 mysqldump result with the fresh 6.0.1 WAR ?)
 
 Thanks for your help!
 Sylvain
 
 
 Sylvain MARIE
 VTREEM.com
 
 ___
 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

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users