LiveTable JSON example

[Rostyslav_Fitsyk]

Hi!

I’m trying to fill out Livetable based on JSON data.
The property Custom Dispaly contains the following script:

{{velocity}}
#set($columns = ["first_name", "last_name", "editor"])
#set($columnsProperties = {
   "first_name" : { "type" : "text" , "size" : 20, "link" : "view"},
   "last_name" : { "type" : "text" , "size" : 20, "link" : "view"},
   "editor" : { "type" : "list", "class": "XWiki.XWikiUsers"}
})
#set($options = {
  "resultPage":"Test.TestJSON",
  "translationPrefix" : "",
  "rowCount": 10
})
#livetable("organization_directory" $columns $columnsProperties $options)
{{/velocity}}

TestJSON page located at Test space and contains the script:

{{include reference="XWiki.LiveTableResultsMacros" /}}

{{velocity wiki="false"}}
#gridresultwithfilter("XWiki.XWikiUsers" $request.collist.split(",") "" " and doc.name<>'OrganizationSheet' and doc.name<>'OrganizationTemplate'")
{{/velocity}}

When I open the page, I only see the filled-in list of the filter in the editor field:

How do I get a list of users?

Thanks for the help.

[Rostyslav_Fitsyk]

[Rostyslav_Fitsyk]

What would I like to do:

1. Generate a dataset for LiveTable based on a complex HQL query for multiple classes.
2. Display data in LiveTable.

I can write queries and build tables based on classes:
#set ($ options = {
‘className’: ‘Space.Class’
But can not combine 1 and 2.

I will be grateful for a simple step-by-step example.

Thank you for your attention.

[Rostyslav_Fitsyk]

Based on https://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable%20Macro

1. 
2. 
3. 
4. 
5. 

Where is mistake?

Thanks.

[vmassol]

hi, is your Organization.Code.OrganizationClass page a terminal page? If not you need to suffix it with .WebHome.

[Rostyslav_Fitsyk]

I think, yes:

[vmassol]

What about Organization.ListOrganizationJSON? (is it terminal too?)

[Rostyslav_Fitsyk]

Bingo!!!
Changed it to “Terminated” and see expected list!

[Rostyslav_Fitsyk]

Please, also update documentation.
Once again, a huge thank you )

[vmassol]

@Rostyslav_Fitsyk

Please, also update documentation.

I could do that but it would be even more awesome if you could contribute to the doc! It’s a wiki, you just need to register and edit away! Thx

[Rostyslav_Fitsyk]

Ok, done

[vmassol]

Thanks @Rostyslav_Fitsyk. Actually I’ve modified it a bit to move it upwards since this comments is valid for all examples. See https://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable%20Macro?viewer=changes&rev1=103.1&rev2=104.2

[Rostyslav_Fitsyk]