TYPO3 Logo
Low Level
Release: main

Loading data.

  • Introduction
  • Installation
  • Backend modules
    • DB Check
      • Records Statistics
      • Database Relations
      • Full Search
      • Manage Reference Index
    • Configuration
  • Command line
  • Configuration
    • TSconfig
  • Sitemap
  • Index

PAGE CONTENTS

  • Full Search
    • Raw search of all fields
    • Advanced query
      • Example
  1. Start
  2. Backend modules
  3. DB Check
  4. Full Search
View source How to edit Edit on GitHub

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.

../../_images/DB_Check_Full_search.png

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.

../../_images/DB_Check_Advanced_query.png

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”:

../../_images/DB_Check_Advanced_query_tt_content.png

Search for content elements of type header only

  • Previous
  • Next
  • Home
  • Contact
  • Issues
  • Repository

Last updated: Apr 06, 2022 20:30

Last rendered: Apr 07, 2022 11:41

TYPO3 Theme 4.6.2

© Copyright since 1997 by the TYPO3 contributors
  • Legal Notice
  • Privacy Policy