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
