The list module

Almost all data stored in the database is represented as a Database record in the TYPO3 backend.

The respective backend module called Web > List module can be used to view, edit, search and export database records.

How to use the List module effectively for managing database records is described in-depth in Editors Guide, Using the list module.

For example there is a Mass editing mode and a clipboard.

Display of database records in the List module

How a database record type is displayed in the list module is determined by TCA (Table Configuration Array) and can be further configured by TSconfig. While TCA is always loaded globally Tsconfig can be included on a per-site or per-page level.

Here are some examples of what you might want to change in the list module:

Hide tables in the List module

The TSconfig properties in section web_list can be used to influence display and functionality of the List module.

For example you can hide the records of certain tables visible in the List module with:

EXT:site_package/Configuration/page.tsconfig 
mod.web_list {
    hideTables := addToList(tx_my_table,tx_my_table2)
}
Copied!

We use the operator ":=" to add tables to a list that we want to hide.

Disable hide and prepend at copy

By default copied database records are inserted hidden and with (copy X) appended to their label. You can disable this default behaviour by setting disablePrependAtCopy and disableHideAtCopy for the affected table belonging to the record to true like so:

EXT:site_package/Configuration/page.tsconfig 
TCEMAIN.table.tx_my_table {
   disablePrependAtCopy = 1
   disableHideAtCopy = 1
}
Copied!

Define defaults for certain fields

You can override the default (TCA reference) set globally in the TCA (Table Configuration Array) by setting a custom default value in TSconfig TCAdefaults:

EXT:site_package/Configuration/page.tsconfig 
# Do not hide newly created pages by default
TCAdefaults.pages.hidden = 0

# Set the author of a news to "Anonymous"
TCAdefaults.tx_news_domain_model_news.author = Anonymous
Copied!