Attention

TYPO3 v9 has reached its end-of-life September 30th, 2021 and is not maintained by the community anymore. Looking for a stable version? Use the version switch on the top left.

You can order Extended Long Term Support (ELTS) here: TYPO3 ELTS.

be.tableList

ViewHelper which renders a record list as known from the TYPO3 list module.

Note

This feature is experimental!

Examples

Minimal:

<f:be.tableList tableName="fe_users" />

List of all "Website user" records stored in the configured storage PID. Records will be editable, if the current backend user has got edit rights for the table fe_users.

Only the title column (username) will be shown.

Context menu is active.

Full:

<f:be.tableList tableName="fe_users" fieldList="{0: 'name', 1: 'email'}"
    storagePid="1"
    levels="2"
    filter="foo"
    recordsPerPage="10"
    sortField="name"
    sortDescending="true"
    readOnly="true"
    enableClickMenu="false"
    clickTitleMode="info"
    />

List of "Website user" records with a text property of foo stored on PID 1 and two levels down. Clicking on a username will open the TYPO3 info popup for the respective record

Arguments

tableName

DataType

string

Required

false

Description

Name of the database table

fieldList

DataType

mixed

Default

array ()

Required

false

Description

List of fields to be displayed. If empty, only the title column (configured in $TCA[$tableName]['ctrl']['title']) is shown

storagePid

DataType

mixed

Required

false

Description

By default, records are fetched from the storage PID configured in persistence.storagePid. With this argument, the storage PID can be overwritten

levels

DataType

mixed

Required

false

Description

Corresponds to the level selector of the TYPO3 list module. By default only records from the current storagePid are fetched

filter

DataType

string

Required

false

Description

Corresponds to the "Search String" textbox of the TYPO3 list module. If not empty, only records matching the string will be fetched

recordsPerPage

DataType

mixed

Required

false

Description

Amount of records to be displayed at once. Defaults to $TCA[$tableName]['interface']['maxSingleDBListItems'] or (if that's not set) to 100

sortField

DataType

string

Required

false

Description

Table field to sort the results by

sortDescending

DataType

mixed

Required

false

Description

If TRUE records will be sorted in descending order

readOnly

DataType

mixed

Required

false

Description

If TRUE, the edit icons won't be shown. Otherwise edit icons will be shown, if the current BE user has edit rights for the specified table!

enableClickMenu

DataType

mixed

Default

true

Required

false

Description

Enables context menu

clickTitleMode

DataType

string

Required

false

Description

One of "edit", "show" (only pages, tt_content), "info