liquidlight / module-data-listing
Filterable, searchable and sortable datatables for the TYPO3 backend. Fe_users comes as default.
Installs: 542
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 3
Forks: 2
Type:typo3-cms-extension
Requires
- typo3/cms-core: ^9.5 || ^10.4
README
Overview
This package provides you with a backend datatable view of fe_users allowing you to sort, search and export your fe_users as well as filter by usergroup.
By default, the following columns are shown:
- ID
- Username
- Usergroup
- Title
- First name
- Last name
By default, the following columns are searchable:
- ID
- Username
- First name
- Last name
Settings
There are a few different settings that can be set on a site-by-site basis via typoscript.
Joins
It is possible to bolt on data from related tables by making use of the module.tx_moduledatalisting.settings.joins
object where:
type
can be leftJoin, rightJoin or innerJointable
is the name of the related tablelocalIdentifier
is the unique identifier of the related tableforeignIdentifier
is the matching field in the fe_users table
Setup
module.tx_moduledatalisting {
settings {
joins {
1 {
type = leftJoin
table = related_table
localIdentifier = uid
foreignIdentifier = related_table_uid
}
}
}
}
Additional columns
It is possible to pull in additional columns from the fe_users table as well as columns from any join tables by making use of the module.tx_moduledatalisting.settings.additionalColumns
object where:
table
is the name of the table you wish to pull the additional column from (this can be fe_users or any joined tables)column
is the name of the column you wish to pull inlabel
is the label that is used in the datatable header
Setup
module.tx_moduledatalisting {
settings {
additionalColumns {
table {
column = label
}
}
}
}
Searchable columns
The default searchable columns are specified above however it is possible to add and/or remove columns from this list by making use of the module.tx_moduledatalisting.settings.searchableColumns
object where:
table
is the name of the table you wish to pull the searchable column from (this can be fe_users or any joined tables)column
is the name of the column you wish to make searchable
Setup
module.tx_moduledatalisting {
settings {
searchableColumns := addToList(table.column1,table.column2)
searchableColumns := removeFromList(table.column3)
}
}
It is also possible to completely reset the searchable columns:
module.tx_moduledatalisting {
settings {
searchableColumns = table.column1,table.column2
}
}