Hi, I suffered to find hql query to use $xwiki.activitystream.method but if I use where condition on eventid field I obtain this error :-( Caused by: org.hibernate.QueryException: could not resolve property: EventId of: com.xpn.xwiki.plugin.activitystream.impl.ActivityEventImpl [select act from com.xpn.xwiki.plugin.activitystream.impl.ActivityEventImpl as act where act.EventId='757328280-1453216488000-dishFheu' order by act.date desc] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)

...

...

Did you try using

...

searchEvents and building an HQL that

 

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

_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users