Attention

TYPO3 v6 has reached its end-of-life April 18th, 2017 and is not maintained by the community anymore. Looking for a stable version? Use the version switch on the top left.

There is no further ELTS support. It is strongly recommended updating your project.

Support for custom tables in the Page module

In the Web > Page module you can have listings of other records than Content Elements. Any table can be displayed by adding to the array $TYPO3_CONF_VARS['EXTCONF']['cms'].

The TYPO3 CMS Core itself defines such a listing for the "fe_users" table:

'EXTCONF' => array(
        'cms' => array(
                'db_layout' => array(
                        'addTables' => array(
                                'fe_users' => array(
                                        0 => array(
                                                'MENU' => '',
                                                'fList' => 'username,usergroup,name,email,telephone,address,zip,city',
                                                'icon' => TRUE
                                        )
                                )
                        )
                )
        )
),

as found in typo3/sysext/core/Configuration/DefaultConfiguration.php.

The "fList" key value is a list of field names separated first by comma and then ";" (semi-colon). The comma separates table columns while the semi-colon allows you to list more than one field to be displayed inside a single column.

So placing yourself on a page containing frontend users in the Web > Page module, you will see the following:

Page module with records list

List of FE users in the Web > Page module