Wiki source code of Live Table component
Version 84.1 by ElenaOanaTabaranu on 2009/09/14
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
58.1 | 1 | = Live Table component = |
| |
27.1 | 2 | |
| |
62.1 | 3 | {{velocity filter="indent"}} |
| |
70.1 | 4 | {{html clean="false" wiki="true"}} |
| |
82.1 | 5 | #warning("This document is a draft.") |
| 6 | |||
| |
27.1 | 7 | #warning("This section documents a feature that is only available starting with XWiki Enterprise 1.9M2.") |
| 8 | |||
| |
68.1 | 9 | {{toc start=2 depth=6 numbered=false scope=page /}} |
| |
27.1 | 10 | |
| |
58.1 | 11 | == Summary == |
| |
27.1 | 12 | |
| |
72.1 | 13 | The **"Live Table"** component is a dynamic table loading data lazily using ajax requests as the user browse the table, in order to scale easily the display of very large amounts of data. Users can browse the table thanks to a pagination system. Filters on columns are available to search for specific entries. Columns can be made sortable in both direction. For a demonstration of the main capabilities of the live table component check out this [[video>>http://vimeo.com/4474332]]. |
| |
65.1 | 14 | |
| |
58.1 | 15 | == How to use == |
| |
27.1 | 16 | |
| |
58.1 | 17 | The Live Table component is made available in several ways to [[Applications>>code:Applications.WebHome]] developers and developers of the [[XWiki platform and products>>dev:Main.WebHome]], depending on their specific needs. The simplest, and most of the times preferred, way to embed a Live Table component is to use the <tt>livetable</tt> velocity macro, available in all pages of your wiki. With only one call to this macro, you will be able to display a live table of the data of your choice! For more specific needs, in the cases you need more control on the table behavior, or to build another component on top of the live table, it is possible to instantiate the live table from JavaScript. In this case, you, as opposed to the velocity macro, you will need to construct the HTML elements the JavaScript component expects yourself, either from JavaScript, either writing the [[HTML directly in your wiki page>>platform:Main.XWikiSyntax]] |
| |
27.1 | 18 | |
| |
72.1 | 19 | === Using the Velocity livetable macro === |
| |
27.1 | 20 | |
| |
58.1 | 21 | Please refer [[Live Table Macro>>code:Macros.LiveTableMacro]] reference. |
| |
27.1 | 22 | |
| |
58.1 | 23 | === HTML + JavaScript === |
| |
27.1 | 24 | |
| |
58.1 | 25 | This is a dynamic component which must me used carefully because of performance issues. The HTML content of the Live Table is automatically updated using Javascript and [[JSON>>http://www.json.org]] code generated with the [[Live Table Macro>>code:Macros.LiveTableMacro]]. |
| |
27.1 | 26 | |
| |
58.1 | 27 | === Example === |
| |
30.1 | 28 | |
| 29 | The Live Table component could be extended with a special column containing the ratings of some documents from the wiki. | ||
| |
58.1 | 30 | The first step would be to generate the JSON code of the column we want to add. In order to achieve this goal we need to modify the result page of the velocity live table macro with our custom page **TutorialsCode.LiveTableRatings**: |
| |
32.1 | 31 | |
| |
61.1 | 32 | {{code language=html}} |
| |
84.1 | 33 | #* |
| |
55.1 | 34 | #set($collist = ["doc.name", "_ratings", "doc.date", "doc.author", "_actions"]) |
| |
52.1 | 35 | |
| |
57.1 | 36 | #set($colprops = { |
| |
32.1 | 37 | "doc.name" : { "type" : "text" , "size" : 30, "sortable":true, "filterable":true}, |
| 38 | "_ratings" : { "sortable":false}, | ||
| 39 | "doc.date" : { "type" : "date" }, | ||
| 40 | "doc.author" : { "type" : "text", "link" : "author"}, | ||
| |
51.1 | 41 | "_actions" : { "actions": ["copy","delete","rename","rights"]} |
| |
57.1 | 42 | }) |
| 43 | #set($options = { "resultPage":"TutorialsCode.LiveTableRatings", | ||
| 44 | "tagCloud" : true, | ||
| 45 | "translationPrefix" : "xe.index.", | ||
| 46 | "rowCount": 10 }) | ||
| 47 | #set($ok = $xwiki.ssx.use("TutorialsCode.LiveTableRatings")) | ||
| 48 | #set($ok = $xwiki.jsx.use("TutorialsCode.LiveTableRatings")) | ||
| |
84.1 | 49 | #livetable("alldocs" $collist $colprops $options) *# |
| |
58.1 | 50 | {{/code}} |
| |
32.1 | 51 | |
| |
76.1 | 52 | If we want to display the rated documents from a certain space, e.g. ~~Tutorials~~, the last parameter of the <tt>#gridresultwithfilter</tt> must contain the query we need. |
| |
58.1 | 53 | {{/html}} |
| 54 | {{/velocity}} | ||
| |
34.1 | 55 | |
| |
61.1 | 56 | {{code language=html}} |
| |
34.1 | 57 | #includeMacros("TutorialsCode.LiveTableResultsMacros") |
| |
59.1 | 58 | |
| |
34.1 | 59 | #gridresultwithfilter("" $request.collist.split(",") "" "doc.space='Tutorials' and doc.name<>'WebHome' and doc.name<>'WebPreferences'") |
| |
59.1 | 60 | |
| |
60.1 | 61 | {{/code}} |
| |
73.1 | 62 | |
| |
77.1 | 63 | The page at *TutorialsCode.LiveTableResultsMacros* should contain a copy of the default code for the live table result page. The next step implies extracting the rating information from the wiki pages located the ~~Tutorials~~ space. We add a new velocity macro which will test the presence of the rating object with class *XWiki.AverageRatingsClass* and extract the rating value. |
| |
73.1 | 64 | {{code language=html}} |
| |
81.1 | 65 | ## |
| 66 | ## list ratings | ||
| 67 | ## | ||
| |
73.1 | 68 | #macro(grid_ratings $udoc) |
| 69 | #set($ratings = "") | ||
| 70 | #set($ratingObj = "") | ||
| 71 | #set($ratingObj = $udoc.getObject("XWiki.AverageRatingsClass")) | ||
| 72 | #if("$!ratingObj" != "") | ||
| 73 | #set($ratings = $ratingObj.get("averagevote")) | ||
| 74 | #end | ||
| 75 | #end | ||
| |
74.1 | 76 | {{/code}} |
| |
78.1 | 77 | The continue our extension of this component, we need to add a test for the presence of our custom column to call the <tt>grid_ratings</tt> macro when generating the JSON: |
| |
75.1 | 78 | {{code language=html}} |
| 79 | ... | ||
| |
79.1 | 80 | #elseif($colname=="_images") , |
| 81 | #grid_photolist($udoc) | ||
| 82 | "${colname}" : "${photolist}" | ||
| |
75.1 | 83 | #elseif($colname=="_ratings"), |
| 84 | #grid_ratings($udoc) | ||
| 85 | "${colname}" : "${ratings}" | ||
| |
79.1 | 86 | #else , |
| |
75.1 | 87 | ... |
| 88 | {{/code}} | ||
| |
73.1 | 89 | |
| |
80.1 | 90 | #info("Firebug can be a useful tool when testing the JSON code generated.") |
| |
75.1 | 91 | |
| 92 | |||
| |
80.1 | 93 |
