Full Search

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.

The Full search action

Advanced query

If you select the option Advanced query you can choose the table to search and search in different fields.

The Advanced query action

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 (SQL table 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.

Example

Search for content elements of type “Header”:

Search for content elements of type header only