#103693datetime fields rendering / TCA
Description
datetime fields are renderend differently (with timezone shift) in titles inside the record editor (record title, inline record title):
*Correct in list view:*
Bildschirmfoto%20vom%202024-04-21%2012-07-31.png
*Incorrect in edit-view:*
Bildschirmfoto%20vom%202024-04-21%2012-28-46.png
*Incorrect in inline headers:*
Bildschirmfoto%20vom%202024-04-21%2012-11-40.png
*???*
Bildschirmfoto%20vom%202024-04-21%2012-09-40.png
Elsewhere (Title in Record list in backend, also in Frontend and datetime edit field in backend) the rendering is correct, without timezone shift.
TCA (record with date displayed wrong, reffered record):
'label' => 'date_time',
'label_alt' => 'title, location_name, location_city',
'label_alt_force' => true,
...
...
'date_time' => array(
'exclude' => 0,
'label' => $LLL_nemtourdates_date.'date_time',
'config' => array(
'type' => 'input',
'renderType' => 'inputDateTime',
'dbType' => 'datetime',
'eval' => 'datetime,requiered'
),
),
TCA edited record:
'label_alt' => 'last_name, first_name, date',
'label_alt_force' => true,
...
...
'date_time' => array(
'exclude' => 0,
'label' => $LLL_nemtourdates_ticketreservation.'date_time',
'config' => array(
'type' => 'input',
'renderType' => 'inputDateTime',
'dbType' => 'datetime',
'eval' => 'datetime'
),
),
'date' => array(
'exclude' => 0,
'label' => $LLL_nemtourdates_ticketreservation.'date',
'config' => array(
'type' => 'inline',
'foreign_table' => 'tx_nemtourdates_domain_model_date',
'overrideChildTca' => array(
'types' => array(
1 => array('showitem' => '--palette--;;show_short,--palette--;;price_short')
),
'columns' => array(
'location_name' => [ 'config' =>[ 'readOnly' => true ] ],
'play' => [ 'config' =>[ 'readOnly' => true ] ],
'price_regular' => [ 'config' =>[ 'readOnly' => true ] ],
'price_kids' => [ 'config' =>[ 'readOnly' => true ] ],
'price_reduced' => [ 'config' =>[ 'readOnly' => true ] ],
'currency' => [ 'config' =>[ 'readOnly' => true ] ],
)
),
'behaviour' => array(
'enableCascadingDelete' => false,
),
'appearance' => array(
'enabledControls' => array(
'info' => true,
'hide' => false,
'delete' => false
)
),
'maxitems' => 1
),
),Reviews 6
- main 86925[TASK] Transform all dates in DatabaseRowDateTimeFields to DateTime
- 13.4 88944[BUGFIX] Use DateTimeFactory for database datetime value interpretation
- main 88826[BUGFIX] Use DateTimeFactory for database datetime value interpretation
- 12.4 87008[BUGFIX] Fix rendering of native datetime fields as record title
- 13.4 87012[BUGFIX] Fix rendering of native datetime fields as record title
- main 86917[BUGFIX] Fix rendering of native datetime fields as record title
Files 4
History 712
-
This Mächler commented and changed attached Bildschirmfoto vom 2024-04-21 12-28-46.png <span data-processor="relativetime" data-value="2024-04-21T10:30:36+00:00" > 04/21/24, 10:30 </span>
-
Chris Müller changed subject
datetime fields rendereding / TCAdatetime fields rendering / TCA <span data-processor="relativetime" data-value="2024-04-21T13:18:38+00:00" > 04/21/24, 13:18 </span> -
Benjamin Franzke changed description <span data-processor="relativetime" data-value="2024-11-06T17:11:34+00:00" > 11/06/24, 17:11 </span>
-
Benjamin Franzke changed description status
NewAccepted <span data-processor="relativetime" data-value="2024-11-07T12:09:24+00:00" > 11/07/24, 12:09 </span> -
Benjamin Franzke changed description <span data-processor="relativetime" data-value="2024-11-07T12:11:49+00:00" > 11/07/24, 12:11 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 86917 status
AcceptedUnder Review <span data-processor="relativetime" data-value="2024-11-07T13:01:40+00:00" > 11/07/24, 13:01 </span> -
Gerrit Code Review pushed patch set 2 for main to change 86917 <span data-processor="relativetime" data-value="2024-11-07T13:59:44+00:00" > 11/07/24, 13:59 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 86917 <span data-processor="relativetime" data-value="2024-11-07T14:06:47+00:00" > 11/07/24, 14:06 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 87012 <span data-processor="relativetime" data-value="2024-11-18T08:02:32+00:00" > 11/18/24, 08:02 </span>
-
Gerrit Code Review pushed patch set 1 for 12.4 to change 87008 <span data-processor="relativetime" data-value="2024-11-18T08:50:55+00:00" > 11/18/24, 08:50 </span>
-
Benjamin Franzke commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2024-11-18T09:05:10+00:00" > 11/18/24, 09:05 </span>Applied in changeset commit:27e16d6b7f8ea3cee554e3e335e88066c6f067cd.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:33:22+00:00" > 12/02/25, 14:33 </span>
See this screenshot. It shows the core of the bug (compare title to datetime edit field