Livetable Macro

Last modified by Manuel Leduc on 2024/01/04 15:56

tableDisplays a dynamic, filterable and sortable table of data
TypeDoc (Velocity Macro)
Category
Developed byUnknown
Rating
1 Votes
LicenseGNU Lesser General Public License 2.1
Bundled With

XWiki Standard

Compatibility

XWiki Enterprise >= 1.9M2

Description

The most common use case of the livetable macro is displaying a table of documents that contains an XWiki Object of a certain class. This is a powerful way for in-wiki applications developers to offer a mining interface on their application data (for example Contacts in a CRM/Contact manager, Bills in a Billing application, etc.).

Usage

The signature of the macro is the following :

#livetable($id $columns $columnsProperties $options)

Each parameter allows to control the output generated by the macro. Namely:

  • $id is a string identifier that allows to distinguish this table from others. This permits to have several tables on the same page. This id is used in the generated HTML as prefix for some elements' ids.
  • $columns is an array that holds the ordered list of columns to display in the table.
  • $columnsProperties is a hash of properties (options) to customize the behavior of each of the columns
  • $options is a hash with general options (as opposed to columns options) for the table.

The following sections give more details and examples about the last three parameters, $options, $columns and $columnsProperties.

Parameter $options

Example

#set($myTableOptions = {
  "className":"XWiki.XWikiUsers",
  "translationPrefix" : "xe.index.users.",
  "tagCloud" : true,
  "rowCount": 10
})

All accepted values

Option nameDescriptionDefault valueSince
classNameThe full name of the XWiki page holding the class definition for the type of data to display in the table. For example: XWiki.XWikiUsers to display pages with objects of type users. If no className is given (nor any of the resultPage or url options - see below), the table will display all pages of the wiki. This parameter can be ignored by a custom data source if either the resultPage or the url parameters are used.None 
resultPageThe 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.). This parameter will be ignored if the url parameter is used.None 
urlThis is similar to resultPage, except that it accepts an URL instead of the full name of the page to obtain results from. This allows for example to add extra query parameters.None 
selectedColumnThe name of the column on which to sort the live table by default. If this option is absent, the first sortable column met in the $columns array will be used.None 
defaultOrderThe default order to sort on the selected column. Accepted values are asc and descasc 
rowCountThe maximum number of rows to display in one page of the table.15 
maxPagesThe maximum number of pages links to display in the pagination UI (Not including the links to the first and last pages that will always be displayed).10 
translationPrefixA string to prefix table translation keys with (for names of columns for example) in order to have different display messages (translated strings) for different tables.None 
tagCloudDisplay a tag cloud filter and display interface to allow users to see entries matching particular tags and to see which tags match the current filter selectionfalse 
selectedTagsThe list of tags that should be selected initially in the tag cloud. You can still select different tags from the tag cloud after the live table loads.[]5.4RC1
callbackAn advanced option to pass the name of a JavaScript method as custom handler of matched rows, leaving the responsibility of the DOM construction of the row entry, and its injection in the table to this method. This option should be used when complex manipulations are needed to construct row entries, which is not possible to do using the default handler.None 
extraParamsUsed to add extra parameters to the Ajax request for the resultPage which generates the JSON data. Must start with an "&" (If you add multiple settings when using this option they have to be separated with an "&"). You should also use the EscapeTool to URL-encode any special character in your parameter values (e.g. the space name since that space can contain any character). For example: 'extraParams' : "&space=$escapetool.url('ComitĂȘ')". The parameters allowed depend on the implementation of the resultPage. For the default resultsPage (i.e. XWiki.LiveTableResults) here's what's supported:
  • space: Find all the documents from a given specific space (Nested Spaces are not included). Example: "extraParams" : "&space=${doc.space}" (for all the documents in the current space).
  • parent: Find all the documents having a specific parent field (not used anymore with Nested Spaces). Example: "extraParams" : "&parent=${doc.space}.WebHome"
  • orphaned: Find all the orphaned documents, i.e. documents having an empty parent field (not used anymore with Nested Spaces). Example: "extraParams" : "&orphaned=1"
  • location (new in XWiki 8.1M2): Finds all the documents having a part of their full reference path matching the passed value. Example: "extraParams" : "&location=pa" would match a document at France.Paris.Beaubourg.WebHome. Note that it's possible to filter using the / character instead of the . one.
  • Custom xproperty. Find all the documents having objects that have a specific value for a property ("extraParams" : "&yourProperty=yourValue" - note that in this particular case, yourProperty has to be declared in the $columns array). This option can also be used to view properties of classes other than the one declared in className ("extraParams" : "&yourProperty_class=yourSpace.yourClass" - sorting and filtering available from version 6.2.1.)
None 
topFiltersHTML fragment that will be placed in a "top filter" area in the same fashion as the Tag Cloud filter. All filters elements (input, select) in this fragment will be automatically used as filters for the livetable.None2.3 RC 1
pageSizeDisplay a selection box to allow users to change the number of rows displayed per page in the tabletrue2.4 M1
pageSizeBoundsDefines the page sizes available in the selection box that allows users to change the number of rows displayed per page in the table. This should be a valid initialization of a Javascript array of 3 integer values: the minimum page size, the maximum page size, and the steps between proposed page sizes. The default value propose a selection between 10 and 100 with a step of 10, which means 10, 20, 30, ..., 90 and 100 in the proposed list of sizes.[10,100,10]2.4 M1
queryFiltersOptionally specifies a comma-separated list of already registered Query filter names to apply. Pass the empty string if you don't want any query filters to be applied. If not specified, the default query filters are applied.
Note: This is not the place where you would add "WHERE" clauses, but it`s for the actual name of existing query filters (e.g. "unique", "hidden", etc.). If extra "WHERE" clauses is what you are looking for, then you should use the extraParams option instead.
currentlanguage, hidden6.0 M1
outputOnlyHtmlIf set to true, it ensures that the output of the livetable macro is only HTML markup, without the syntax specific wrappers ({{html}}{{/html}} macro wrapper for syntax 2.0 or {pre}{/pre} wrappers for syntax 1.0). It is most useful when using the livetable macro inside filesystem velocity templates.false6.3 M2
descriptionWhen provided, the value is used for the caption of the Livetable.the empty string, option6.0 M1

Parameter $columns

This parameter allows to define the columns of the Live Table. There are 3 major types of columns a table can declare: document columns, which will be displaying (and filtering on) metadata on the document (such as its author, date of last modification, etc.), object properties columns, for the case the table is bound to an XWiki Class, and special columns, for columns which are not handled by the first two types, such as the list of attachments of a document, the actions that can be performed. The table below in the example summarizes all the possible values that can be passed to the $columns array.

Example

#set($myColumns = ["_avatar", "first_name", "last_name", "email", "doc.creationDate", "_actions"])

All accepted values

NameDescription
doc.nameThe name of the document (for example, WebHome, in Sandbox.WebHome).
doc.titleThe title of the document.
doc.spaceThe space of the document (for example, Sandbox, in Sandbox.WebHome).
doc.locationThe location of the document (for example, Main / Sandbox, in Sandbox.WebHome). Note that the returned value of this column will automatically be treated as html.
doc.fullNameThe full name of the document (for example Sandbox.WebHome).
doc.creationDateThe date at which the document was created.
doc.creatorThe username of the user that created the document.
doc.authorThe username of the last author of the document.
doc.dateThe date at which the document has been last modified.
doc.objectCountThe number of objects of the type indicated by the className parameter found on the page. This column is useful only if you expect your pages to have multiple objects of the className type. If that is the case then you should probably also use the unique query filter (see the queryFilters parameter).
${propertyName}Any property of an XWiki Class the table is bound to, or from any secondary classes. (See the className and extraParams from the $option argument for more information on how to bind a table to an XWiki Class and how to view propertis from other classes).
_imagesA special column to display all images attached to the retrieved document.
_attachmentsA special column to display links to all attachments of the retrieved document.
_actionsA special column to display a list of actions that can be performed on the matched documents.
_avatarA special column to display the user avatar. Works only for a table bound to the XWiki.XWikiUsers XWiki class.

Parameter $columnsProperties

Example

#set($columnsProperties = {
  "_avatar" : { "type" : "none", "link" : "none", "html" : "true", "sortable":false },
  "first_name" : { "type" : "text" , "size" : 20, "link" : "view"},
  "last_name" : { "type" : "text", "link" : "view"},
  "email" : { "type" : "text", "html" : "true" }
})

All accepted values

  • Document and object fields options:
    NameDescriptionsDefault valueSince
    displayNameThe name to display as a column header for this column (wins over the translationPrefix table option) (Note: available starting with XE 2.3)None2.3
    filterableShould the column present a filter on its header?true12 
    sortableShould the column be available as a sort key?true 
    typeFor filterable columns, the type of filter for the column. Valid values are:
    • hidden (allows to hide a column)
    • text
    • list
    • number
    • boolean since 8.2M2
    • multilist since 8.2M2 (allows the user to filter on multiple values of a list)
    • date since 9.5RC1 
    • suggest since 9.8 (supported by Database List, List of Users and List of Groups property types).
    None (no type) 
    match(6.3M1+) For filterable columns, specifies how the filter value should be matched against the stored value. Possible values are: exact, partial, prefix. The default live table results page is currently supporting this option for the following property types: StringProperty, LargeStringProperty and DBStringListProperty. Custom live table results pages might not provide this option.None (depends on the column data type) 
    sizeThe size of the filter field. CSS might override this value to make the field 100%.None 
    link

    The type of link to use for this column. The following options are available, in order:

    • auto: link to the URL provided by the <columnName>_url row property from the JSON results, if present, otherwise fall back on the doc_url property
    • field: same as auto but without the fallback; this can be used for instance with Database List properties in order to link the column value to the corresponding XWiki document
    • editor: link to edit the corresponding object property (requires LiveTable Property Editor)
    • <property>: link to the URL provided by the doc_<property>_url row property from the JSON results, if present, otherwise fall back on the doc_url property. The following properties are currently supported by the default live table results JSON: author, space, wiki, 9.1+ edit, copy, delete, rename, rights. You can of course use other properties as long as you add doc_<property>_url to your custom JSON results.

    Note that you need to set the doc_viewable row property to true in order for these values to be taken into account. Leave this empty or don't specify it at all if you don't want to link the column value.

    None (no link) 
    htmlShould the returned value be treated as HTML and injected as is in the row ?false 
    headerClassThe name of an optional CSS class to add to the column HTML table column header.None2.3 RC 1
    classSpecifies the full name of the XWiki class for the type of data to display in the table. Used by the filtering options in the live table header, when the $options hash has resultPage key instead of className or when the column comes from a different object than the one pointed to by className .None 
  • _actions options:
    NameDescriptionsDefault valueSince
    actionsThe list of actions to display on this column. An action can be specified as a string (the action name) or as a map with more advanced action properties. The following list of actions are supported by the default live table results page: view, edit, copy, rename, delete, rights. The action URL for each row is specified by the doc_actionName_url field in the live table JSON. E.g.:
    'actions': [
     'edit', 'delete',
      {
       'id': 'custom',
       'label': 'Custom',
       'icon': 'eye',
       'async': true,
       'callback': 'callSomeJavaScriptFunction()'
      }, {
        ...
      }
    ]
    [] 

Examples

In all examples below, we are using references to "Terminal" wiki pages. By default when you create new pages in XWiki they are created a Nested Pages and their references ends with .WebHome. Thus adapt the examples accordingly when trying to use them on your own use cases.

The user directory

#set($columns = ["_avatar", "first_name", "last_name", "email", "doc.creationDate", "_actions"])
#set($columnsProperties = {
   "_avatar" : { "type" : "none", "link" : "none", "html" : "true", "sortable":false },
   "first_name" : { "type" : "text" , "size" : 20, "link" : "view"},
   "last_name" : { "type" : "text", "link" : "view"},
   "email" : { "type" : "text", "html" : "true"}
})
#set($options = {
  "className":"XWiki.XWikiUsers",
  "translationPrefix" : "xe.userdirectory.",
  "tagCloud" : true,
  "rowCount": 10
})
#livetable("userdirectory" $columns $columnsProperties $options)

The url option can also be used to generate the user directory:

#set($options = {
  "url" : "$xwiki.getURL('XWiki.LiveTableResults', 'get', 'outputSyntax=plain&transprefix=xe.index.users.&classname=XWiki.XWikiUsers&collist=_avatar,first_name,last_name,email,doc.creationDate')",
  "translationPrefix" : "xe.userdirectory.",
  "tagCloud" : true,
  "rowCount": 10
})

Demo (Video)

  1. ^ note that filtering on doc.title does not work as expected and was disabled before XWiki 10.9
  2. ^ Before 9.5RC1 only list, text, number are filterable. Since 9.5RC1, date type columns can also be filtered. If you are on an older version, you can try out the extension for a date filter.
    

Get Connected