[5.x]: Multi-instance fields with same handle show in different columns

[shifuma]

What happened?

Description

Matrix fields set to view as Element Index show multiple columns of the same field.

Steps to reproduce

1. Create a Matrix field with two entry types
2. Create a generic plain text field
3. Add the plain text field to each entry type -> Settings > rename the handle to myTextField
4. Add myTextField columns to index (there will be two of them)

Expected behavior

If a field has the same handle, the content will show in that column, even if it has been overwritten

Actual behavior

Fields with the same handle show in different columns because the handle has been changed

Craft CMS version

5.4.5

PHP version

No response

Operating system and version

No response

Database type and version

No response

Image driver and version

No response

Installed plugins and versions

[brandonkelly]

This is working as expected. Craft will only consolidate custom field columns across multiple entry types if their handle hasn’t been overridden. Otherwise the field will be identified by its field instance UUID, which is going to be unique for each entry type.

cms/src/services/ElementSources.php

Lines 435 to 444 in d44a2d4

	if ($layoutElement->handle === null) {
	// The handle wasn't overridden, so combine it with any other instances (from other layouts)
	// where the handle also wasn't overridden
	$groupedFieldElements[$field->id][] = $layoutElement;
	} else {
	// The handle was overridden, so it gets its own table attribute
	$attributes["fieldInstance:$layoutElement->uid"] = [
	'label' => Craft::t('site', $field->name),
	];
	}

If you’d like each of these fields to share the same column, remove their overridden handles. If that’s not possible because the same field already exists in the layout with the default handle, you can create a new custom field to hold that data instead. You can then migrate the existing field values over to the new field using this command:

php craft resave/entries \
  --field <matrixFieldHandle> \
  --type <entryTypeHandle> \
  --set <newTextFieldHandle> \
  --to <oldTextFieldHandle>