19 Jan
2016
19 Jan
'16
9:57 a.m.
--- En date de : Mar 19.1.16, vincent(a)massol.net <vincent(a)massol.net> a écrit :
Anyway I found table and field to use an hql query here:
http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema (I must use a ggogle
glass+zoom to see field ;-) )
but my query with $services.query.hql($hql).execute() doesn't work with table name
(rg.hibernate.hql.ast.QuerySyntaxException: activitystream_events is not mapped ).
Then I tested with simple query:
SELECT doc.XWD_TITLE FROM xwikidoc AS doc WHERE doc.XWD_FULLNAME = 'Main.WebHome'
didn't work => Caused by: org.hibernate.hql.ast.QuerySyntaxException: xwikidoc is
not mapped [select doc.XWD_TITLE FROM xwikidoc AS doc WHERE doc.XWD_FULLNAME =
'Main.WebHome']
SELECT doc.title FROM XWikiDocument AS doc WHERE doc.fullName = 'Main.WebHome'
working fine
With velocity+API we can not use hql query with true field/table name?
If we can not then where I can found field/table mapping name for activitystream_events
table?
Thxs
De: vincent(a)massol.net <vincent(a)massol.net>
Objet: Re: [xwiki-users] Fw : Re: How can I get event object through a form
À: "XWiki Users" <users(a)xwiki.org>
Date: Mardi 19 janvier 2016, 8h09
Also note that the AS has
a buitin feature to delete old events, see your xwiki.cfg
file:
....
xwiki.plugin.activitystream.daystokeepevents=0
Yes I know that and delete some event with API :-)
My problem is the way to give some selected event object through a form with
$request.getParameterValues() to delete these events.
If you still need to delete
event manually you could check the code executed by the
scheduler job.
I didn't found it either Scheduler.ActivityStreamCleaner is empty and anyway I suppose
it is groovy code (look into xar source if needed).
Did you try
using
searchEvents and building an HQL that
>