Thanks very much. It helps!
2015-06-16 17:43 GMT+08:00 Marius Dumitru Florea <
mariusdumitru.florea(a)xwiki.com>gt;:
  If you use a custom results page (MySpace.MyJSON) then
*you* are
 responsible for implementing the live table sort and filter. You even
 have a TODO for this in your code
 ## TODO: Add code to filter data
 so I don't understand what you're asking. Of course the sort and
 filter don't work. You need to implement them.
 Hope this helps,
 Marius
 On Tue, Jun 16, 2015 at 10:25 AM,  <withwind303(a)gmail.com> wrote:
  Hi,
   Everyone! My xwiki verison is 6.4.3. I want to use the Livetable macro 
 to
  achieve to manage my table and paging it. But the
table can not sort or
 filter,i really don’t know I was wrong, could you someguys help me? Here 
 is
  my code:
 The page I use livetable code:
 {{velocity}}
 #set($columns = [ "user"  , "message" ])
 #set($columnsProperties = {
     "user" : { "type" : "text" },
     "message" : { "type" : "text"}
 })
 #set($options = {
     "resultPage":"MySpace.MyJSON"
 })
 #livetable("twitter" $columns $columnsProperties $options)
 {{/velocity}}
 MySpace. MyJSON:
 {{velocity wiki="false"}}
 #if("$!{request.xpage}" == 'plain')
   $response.setContentType('application/json')
 #end
 ##==============================
 ## Offset = item # at which to start displaying data
 ##==============================
 #set($offset = $util.parseInt($request.get('offset')))
 ## offset starts from 0 in velocity and 1 in javascript
 #set($offset = $offset - 1)
 #if($offset < 0)
   #set($offset = 0)
 #end
 ##==================
 ## Limit = # of items to display
 ##==================
 #set($limit = $util.parseInt($request.get('limit')))
 ##==================
 ## Tag = one parameter per tag
 ##==================
 #if($request.tag)
   #foreach($tag in $request.getParameterValues('tag'))
     ## TODO: Add code to filter items based on the selected tags
   #end
 #end
 ##==========
 ## Sort direction
 ##==========
 #set($order = "$!request.sort")
 #if($order != '')
   #set($orderDirection = "$!{request.get('dir').toLowerCase()}")
   #if("$!orderDirection" != '' && "$!orderDirection"
!= 'asc')
     #set($orderDirection = 'desc')
   #end
 #end
 ## ===========
 ## Filter Data here...
 ## ===========
 ## TODO: Add code to filter data
 ## Each column can be filtered and the filter for a column can be 
 retrieved
  with:
 ## #set($filterValue = "$!{request.get(<columnname>)}")
 ## ===
 ## JSON
 ## ===
 {
 "totalrows": 2,
 "matchingtags": {},
 "tags" : [],
 "returnedrows":  2,
 "offset": 1,
 "reqNo": $util.parseInt($request.reqNo),
 "rows": [{
   "doc_viewable" : true,
   "user" : "vincent",
   "message" : "vincent's message"
 },{
   "doc_viewable" : true,
   "user" : "jack",
   "message" : "jack's message"
 }]
 }
 {{/velocity}}
 _______________________________________________
 users mailing list
 users(a)xwiki.org
 
http://lists.xwiki.org/mailman/listinfo/users 
_______________________________________________
 users mailing list
 users(a)xwiki.org
 
http://lists.xwiki.org/mailman/listinfo/users