Group fields 

A comma list of tables from $GLOBALS['TCA'] , for example "pages,be_users".

The maximum size (height) of the select field.

The size of the select field will be automatically adjusted based on the number of selected items. The select field will never be smaller than the specified size and never larger than the value of autoSizeMax.

Default value set if a new record is created. If empty, the first element in the items array is selected.

A list of tables which should not be remapped to the new element uids if the field holds elements that are copied in the session.

By default, the last selected page is used when opening the element browser. Setting this configuration value changes this behaviour.

This configuration value is a PHP array , containing table => id pairs. When opening the element browser for a specific table (buttons below the group field), the defined page is then always selected by default. There is also the special _default key, used for the general element browser button (on the right side of the group field), which is not dedicated to a specific table.

This configuration value also supports the known markers ###SITEROOT###, ###CURRENT_PID### and ###PAGE_TSCONFIG_<key>###.

Each table => id pair can also be overridden via page TSconfig.

The field of type group can enable all common field control options. Furthermore the following are available:

The element browser is enabled by default. The speaker of a talk shows it as the folder button:

The element browser control can be disabled by setting disabled = true . The element browser does not list the records of a table with hideTable, such as the talks. A related talk is found with the search field instead:

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_talk', [
  'related_talks' => [
    'label' => 'my_extension.db:talk.related_talks',
    'config' => [
      'type' => 'group',
      'allowed' => 'tx_myextension_talk',
      'MM' => 'tx_myextension_talk_related_mm',
      'fieldControl' => [
        // The element browser does not list talks, because their table is
        // hidden. Editors find a talk with the search field instead.
        'elementBrowser' => [
          'disabled' => true,
        ],
      ],
    ],
  ],
]);
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_talk',
  'related_talks',
  '',
  'before:--div--;core.form.tabs:access',
);

For details see fieldInformation.

For general fieldWizard documentation see here.

Define filters for item values. Doesn't work in combination with a wizard.

This is useful when only foreign records matching certain criteria should be allowed to be used as values in the group field. The values are filtered in the Element Browser as well as during processing in DataHandler. Filter userFuncs should have two input arguments ($parameters and $parentObject). The first argument ($parameters) is an array with the parameters of the filter as configured in the TCA, but with the additional parameter "values", which contains the array of values which should be filtered by the userFunc. The function must return the filtered array of values.

filter is a list of filters. Each filter has a userFunc and optional parameters. The filters are applied one after the other.

Removes the delete icon next to the selector box.

Removes the move icons next to the selector box.

The "suggest wizard" is added by default to all database relation group fields. After a couple of characters have been typed into this field, an ajax based search starts and shows a list of records matching the search word.

The syntax for the search is: "multiple words" something, so you can enclose words you want to find next to each other in double quotes.

A set of options is available to configure search details.

Setting this property to true disables the suggest wizard.

Defines whether referenced records should be localized when the current record gets localized. This only applies if references are not stored using MM tables.

Maximum number of child items. Defaults to a high value. JavaScript record validation prevents the record from being saved if the limit is not satisfied.

Minimum number of child items. Defaults to 0. JavaScript record validation prevents the record from being saved if the limit is not satisfied.

This value contains the name of the table in which to store a MM relation. It is used together with allowed (group). If you use Extbase, foreign_table has to contain the same table name additionally.

The database field with a MM property only stores the number of records in the relation.

Please have a look into the additional information in the MM common property description.

The table name used in the field MM should be unique. It must be a valid SQL table name. It is best practise to use the name of both referenced tables and of the field in which the reference is saved on local side. See also naming conventions for mm tables. This way uniqueness can be ensured and it is possible to find the field where the table is used quickly.

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_talk', [
  'related_talks' => [
    'label' => 'my_extension.db:talk.related_talks',
    'config' => [
      'type' => 'group',
      'allowed' => 'tx_myextension_talk',
      'MM' => 'tx_myextension_talk_related_mm',
      'fieldControl' => [
        // The element browser does not list talks, because their table is
        // hidden. Editors find a talk with the search field instead.
        'elementBrowser' => [
          'disabled' => true,
        ],
      ],
    ],
  ],
]);
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_talk',
  'related_talks',
  '',
  'before:--div--;core.form.tabs:access',
);

Array of field => value pairs to both insert and match against when writing/reading MM relations.

If you want to make a MM relation editable from the foreign side (bidirectional) of the relation as well, you need to set MM_opposite_field on the foreign side to the field name on the local side.

For example, if the field companies.employees is your local side and you want to make the same relation editable from the foreign side of the relation in a field called persons.employers, you would need to set the MM_opposite_field value of the TCA configuration of the persons.employers field to the string "employees".

In a MM bidirectional relation using group match fields the opposite side needs to know about the match fields for certain operations (for example, when a copy is created in a workspace) so that relations are carried over with the correct information.

MM_oppositeUsage is an array which references which fields contain the references to the opposite side, so that they can be queried for match field configuration.

Additional where clause used when reading MM relations.

Example:

{#uid_local} = ###THIS_UID###

The above example uses the special field quoting syntax {#...} around identifiers to be as DBAL-compatible as possible.

Allows the same item more than once in a list.

If used with bidirectional MM relations it must be set for both the native and foreign field configuration.

Will prepend the table name to the stored relations (so instead of storing "23" you will store e.g. "tt_content_23"). This is automatically turned on if multiple different tables are allowed for one relation.

Renders the field in a way that the user can see the value but cannot edit it.

Defines whether the field holds one related record or several. This decides which value a Record object provides for this field, for example in a Fluid template.

oneToOne, manyToOne

The field provides a single Record object, or null if no record is related. maxitems is set to 1 automatically, overriding any other value.

oneToMany

The field provides a LazyRecordCollection of Record objects.

If relationship is not set, the field also provides a collection. So does a field with MM, whatever relationship says. Any other value, including manyToMany, throws an exception unless MM is set.

maxitems does not change the result the other way round: a field without relationship still provides a collection, even if maxitems is 1.

In the following example, each talk has one speaker:

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_talk', [
  'speaker' => [
    'label' => 'my_extension.db:talk.speaker',
    'config' => [
      'type' => 'group',
      'allowed' => 'tx_myextension_speaker',
      'maxitems' => 1,
      'relationship' => 'manyToOne',
      // The speakers are stored in the same folder as the talks
      'elementBrowserEntryPoints' => [
        'tx_myextension_speaker' => '###CURRENT_PID###',
      ],
      'fieldControl' => [
        'editPopup' => [
          'disabled' => false,
        ],
        'addRecord' => [
          'disabled' => false,
        ],
        'listModule' => [
          'disabled' => false,
        ],
      ],
      'behaviour' => [
        'allowLanguageSynchronization' => true,
      ],
    ],
  ],
]);
$GLOBALS['TCA']['tx_myextension_talk']['types']['keynote']['columnsOverrides']['speaker']['config']['minitems'] = 1;
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_talk',
  'speaker',
  '',
  'after:slug',
);

The speaker can then be output without a loop:

Speaker: {talk.speaker.name}

The minimum size (height) of the select field.

The size of the select field will be automatically adjusted based on the number of selected items. The select field will never be smaller than the specified size and never larger than the value of autoSizeMax.

Optional, additional suggest options used if the suggest wizard is not hidden. The suggest wizard options can also be overriden on a page TSconfig level.

Suggestions can be configured differently for each table. Settings in "default" are applied to all tables. In the example below, there is a special setting for the "pages" table to search only standard pages.

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_conference', [
  'related_content' => [
    'label' => 'my_extension.db:conference.related_content',
    'config' => [
      'type' => 'group',
      'allowed' => 'pages,tt_content',
      'elementBrowserEntryPoints' => [
        '_default' => '###SITEROOT###',
      ],
      'suggestOptions' => [
        'default' => [
          'searchWholePhrase' => true,
        ],
        // Only standard pages
        'pages' => [
          'searchCondition' => 'doktype = 1',
        ],
        'tt_content' => [
          'additionalSearchFields' => 'bodytext',
        ],
      ],
    ],
  ],
]);
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_conference',
  'related_content',
  '',
  'before:--div--;core.form.tabs:categories',
);

additionalSearchFields (string)

Comma-separated list of fields the suggest wizard should also search in. By default the wizard looks only in the fields listed in the label and label_alt of TCA ctrl properties.

Example

EXT:my_extension/Configuration/TCA/Overrides/157-tx_myextension_conference-related_content.php

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_conference', [
  'related_content' => [
    'label' => 'my_extension.db:conference.related_content',
    'config' => [
      'type' => 'group',
      'allowed' => 'pages,tt_content',
      'elementBrowserEntryPoints' => [
        '_default' => '###SITEROOT###',
      ],
      'suggestOptions' => [
        'default' => [
          'searchWholePhrase' => true,
        ],
        // Only standard pages
        'pages' => [
          'searchCondition' => 'doktype = 1',
        ],
        'tt_content' => [
          'additionalSearchFields' => 'bodytext',
        ],
      ],
    ],
  ],
]);
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_conference',
  'related_content',
  '',
  'before:--div--;core.form.tabs:categories',
);

Copied!

addWhere (string)

Allows to define an additional where clause for the searchquery. It supplies a marker for ###THIS_UID### which is useful to exclude the current record.

Note

Basically identical to 'searchCondition' - one will vanish sooner or later.

cssClass (string)

Add a CSS class to every list item of the result list.

maxItemsInResultList (integer)

Maximum number of results to display, default is 10.

maxPathTitleLength (integer)

Maximum number of characters to display when a path element is too long.

minimumCharacters (integer)

Minimum number of characters needed to start the search. Works only in "default" configuration array.

orderBy (string)

Allows to add an ORDER BY part to the search query.

pidList (list of values)

Limit the search to certain pages (and their sub pages). When pidList is empty all pages will be included in the search (as long as the be_user is allowed to see them).

The page IDs differ from one installation to the next. An extension therefore does not set them. The site package of the installation can set them in its TCA overrides:

Example

EXT:my_sitepackage/Configuration/TCA/Overrides/tx_myextension_conference.php

<?php

defined('TYPO3') or die();

// The suggest wizard of the related content searches only the pages
// "Program" (6) and "News" (7) of this site, and four levels below them
$GLOBALS['TCA']['tx_myextension_conference']['columns']['related_content']['config']['suggestOptions']['default']['pidList'] = '6,7';
$GLOBALS['TCA']['tx_myextension_conference']['columns']['related_content']['config']['suggestOptions']['default']['pidDepth'] = 4;

// The layout of this site shows the impressions of a conference in 16:9
// only, so the free ratio of the extension is not available
$GLOBALS['TCA']['tx_myextension_conference']['columns']['impressions']['config']
  ['overrideChildTca']['columns']['crop']['config']['cropVariants']['desktop']
  ['allowedAspectRatios']['NaN']['disabled'] = true;

Copied!

pidDepth (integer)

Expand pidList by this number of levels. Has an effect only if pidList has a value. See the example of pidList.

receiverClass (string)

PHP class alternative receiver class, default is \TYPO3\CMS\Backend\Form\Wizard\SuggestWizardDefaultReceiver . Can be used to implement an own search strategy.

renderFunc (string)

User function to manipulate the displayed records in the results.

searchCondition (string)

Additional WHERE clause (not prepended with AND ).

Note

Basically identical to 'addWhere' - one will vanish sooner or later.

Example

EXT:my_extension/Configuration/TCA/Overrides/157-tx_myextension_conference-related_content.php

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_conference', [
  'related_content' => [
    'label' => 'my_extension.db:conference.related_content',
    'config' => [
      'type' => 'group',
      'allowed' => 'pages,tt_content',
      'elementBrowserEntryPoints' => [
        '_default' => '###SITEROOT###',
      ],
      'suggestOptions' => [
        'default' => [
          'searchWholePhrase' => true,
        ],
        // Only standard pages
        'pages' => [
          'searchCondition' => 'doktype = 1',
        ],
        'tt_content' => [
          'additionalSearchFields' => 'bodytext',
        ],
      ],
    ],
  ],
]);
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_conference',
  'related_content',
  '',
  'before:--div--;core.form.tabs:categories',
);

Copied!

searchWholePhrase (boolean)

Whether to do a LIKE=%mystring% (searchWholePhrase = 1) or a LIKE=mystring% (to do a real find as you type), default is 0.

Example

EXT:my_extension/Configuration/TCA/Overrides/157-tx_myextension_conference-related_content.php

<?php

use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;

defined('TYPO3') or die();

ExtensionManagementUtility::addTCAcolumns('tx_myextension_conference', [
  'related_content' => [
    'label' => 'my_extension.db:conference.related_content',
    'config' => [
      'type' => 'group',
      'allowed' => 'pages,tt_content',
      'elementBrowserEntryPoints' => [
        '_default' => '###SITEROOT###',
      ],
      'suggestOptions' => [
        'default' => [
          'searchWholePhrase' => true,
        ],
        // Only standard pages
        'pages' => [
          'searchCondition' => 'doktype = 1',
        ],
        'tt_content' => [
          'additionalSearchFields' => 'bodytext',
        ],
      ],
    ],
  ],
]);
ExtensionManagementUtility::addToAllTCAtypes(
  'tx_myextension_conference',
  'related_content',
  '',
  'before:--div--;core.form.tabs:categories',
);

Copied!