[xwiki-users] Fw : Re: Fw : Re: Fw : Re: How can I get event object through a form - xwiki-users@xwiki.org

20 Jan 2016

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(a)xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users