New subject: [xwiki-users] Fw : livetable with multiple class?

27 Mar 2015

--- En date de : Ven 27.3.15, Pascal BASTIEN &lt;pbasnews-xwiki(a)yahoo.fr&gt; a écrit :

...
  De: Pascal BASTIEN &lt;pbasnews-xwiki(a)yahoo.fr&gt;
 Objet: [xwiki-users]  livetable with multiple class?
 À: "XWiki Users" &lt;users(a)xwiki.org&gt;
 Date: Vendredi 27 mars 2015, 14h19
 If I understand documentation, to use
 Livetable with multiple Class (with 3 or 4 common
 properties: same name) I must use 
 Parameter $options:
 resultPage    The full name of the page to
 use as a JSON data provider for the table. This option
 allows to use a different data source than the default one
 (XWiki.LiveTableResults) for specific needs not handled by
 LiveTableResults (for example: complex cross-classes
 queries, external data retrieved with a groovy script,
 etc.).
  ...
...
  Can I do it with query in one (or two) shots or I must
use a
 foreach loop to rendering my JSON data? 
I found my query, something like this:
#set($hql = "select obj.name, prop.value from BaseObject obj, StringProperty prop
where ( obj.className='FormSMQ.EAClass' or
obj.className='FormSMQ.PiacJ2Class' ) and prop.id.id=obj.id and
prop.name='TypeFiche_RO'")

Now I need the JSON format of my JSON data provider (resultPage parameter: full name of
the page to use as a JSON data provider for the table)