[!!!][TASK] Remove TCA option "cruser_id"

[TYPO3IncTeam]

ℹ️ View this commit on Github
👥 Authored by Benni Mack [email protected]
✔️ Merged by Stefan Bürk [email protected]

Commit message

[!!!][TASK] Remove TCA option "cruser_id"

TYPO3's TCA definition has a setting called cruser_id
which automatically is filled with the current TYPO3's
Backend User ID, if created via DataHandler.

However, this information is also available in the
RecordHistory (since its extraction from sys_log in v9)
and can be queried, when needed, directly from there.

This way, all TCA-based tables, having the setting "cruser_id"
do not need to carry this value anymore, as it is duplicated
in TYPO3's data model.

This change removes the evaluation of "cruser_id",
and removes the filling of this property via DataHandler.

The DB field is also not set anymore automatically.

The Info popup (ElementInformationController) now
shows the information from the RecordHistory information.

Resolves: #98024
Releases: main
Change-Id: I1fe54b0ecfc0ee9b2d1867011dd960e1906fd2d4
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/75123
Tested-by: core-ci [email protected]
Tested-by: Christian Kuhn [email protected]
Tested-by: Stefan Bürk [email protected]
Reviewed-by: Christian Kuhn [email protected]
Reviewed-by: Stefan Bürk [email protected]

➕ Added files

12.0/Breaking-98024-TCA-option-cruserid-removed.rst

.. include:: /Includes.rst.txt

=================================================
Breaking: #98024 - TCA option `cruser_id` removed
=================================================

See :issue:`98024`

Description
===========

The TCA option in the `ctrl` section of each TCA table `cruser_id` has been
removed, along with populating this system-related information within DataHandler
and the auto-creation of the database field.

The setting was used to fill the UID of the Backend User who originally created
the affected row. However, this information is also available through TYPO3's
History functionality, and does not need to be persisted twice.

Several drawbacks came with this feature, which is why it was removed entirely:
* Extbase did not support this functionality
* When a record was created via the Frontend in the plugin, the userid was not available

Information about a record ("Info Popup" or within Workspaces) is now fetched
through TYPO3's History functionality.


Impact
======

When creating new records, the value of the database field is not auto-populated.

Also, when upgrading to TYPO3 v12, the database field is prepared to be removed.

The option :php:`$GLOBALS['TCA'][$tableName]['ctrl']['cruser_id']` is also
automatically removed during cache warmup from the final TCA listing.


Affected Installations
======================

TYPO3 installations actively using this field for querying or filling, not using
TYPO3 API, and accessing the database directly.


Migration
=========

If the need for the information – that is who created the record – is needed,
use the History functionality to fetch the creation details of a record.

If this field is actively queried, it is recommended to add this field as a
regular TCA column with a custom hook or PSR-14 Event to fill this information.

.. index:: Database, TCA, NotScanned, ext:core