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