Users with administrator rights can find this module at System > DB Check > Full Search.
Raw search of all fields¶
This module offers a raw search of all fields. Here you can enter a string and do a raw search.
The result is grouped by record type and there are buttons to edit or get to the info of each record.
If you select the option Advanced query you can choose the table to search and search in different fields.
Chose a table to search in. Then you can search for certain fields. The GUI will let you choose from values that can be entered according to the TCA.
For example you can search in table Page Content
tt_content) for content elements of a certain type, stored in
data base field Type, SQL field
CType. A drop down gives you
options on the search mode (equals, contains, is in list, …) and another
drop down lets you choose the value to search for. In this case it lists all
available content element types.
You can select more options like group by, order by and limit.
It is also possible to save and load queries. The queries will be saved
serialized in the column
uc of table
be_users. It can therefore
not be shared between users.
Just like in the raw search there are buttons to edit or get to the info of each record.
The Advanced query action can be configured with user TSconfig.
Search for content elements of type “Header”: