ModerationStateField.php

<?php

namespace Drupal\content_moderation\Plugin\views\field;

use Drupal\content_moderation\Plugin\views\ModerationStateJoinViewsHandlerTrait;
use Drupal\views\Attribute\ViewsField;
use Drupal\views\Plugin\views\field\EntityField;

/**
 * A field handler for the computed moderation_state field.
 *
 * @ingroup views_field_handlers
 */
class ModerationStateField extends EntityField {
  use ModerationStateJoinViewsHandlerTrait;
  
  /**
   * {@inheritdoc}
   */
  public function clickSort($order) {
    $this->ensureMyTable();
    // This could be derived from the content_moderation_state entity table
    // mapping, however this is an internal entity type whose storage should
    // remain constant.
    $storage = $this->entityTypeManager
      ->getStorage('content_moderation_state');
    $storage_definition = $this->entityFieldManager
      ->getActiveFieldStorageDefinitions('content_moderation_state')['moderation_state'];
    $column_name = $storage->getTableMapping()
      ->getFieldColumnName($storage_definition, 'value');
    $this->aliases[$column_name] = $this->tableAlias . '.' . $column_name;
    $this->query
      ->addOrderBy(NULL, NULL, $order, $this->aliases[$column_name]);
  }

}