Untitled
plain_text
a month ago
818 B
1
Indexable
Never
use Drupal\Core\Database\Database; $entity_id = 123; // Replace with your desired entity ID. // Get the database connection. $database = Database::getConnection(); $query = $database->select('workflow_transition_history', 'wth') ->fields('wth', ['uid']) ->condition('wth.entity_id', $entity_id); $query->leftJoin('user__field_first_name', 'ufn', 'wth.uid = ufn.entity_id'); $query->leftJoin('user__field_last_name', 'uln', 'wth.uid = uln.entity_id'); $query->fields('ufn', ['field_first_name_value']) ->fields('uln', ['field_last_name_value']); $result = $query->execute(); foreach ($result as $row) { $first_name = $row->field_first_name_value; $last_name = $row->field_last_name_value; // Do something with the first and last names. // For example, you can print them or use them as needed. }