How to perform a query using a specific field of a node entity reference

Question

I have a content type that has a node entity reference field. My base query looks like

$event_nids = \Drupal::entityQuery('node') ->condition('type', 'my_content_type') ->execute();

I'd like though to be able to sort by the title field of the referenced field type. I attempted

$event_nids = \Drupal::entityQuery('node') ->condition('type', 'my_content_type') ->sort('field_referenced_node.title', ASC) ->execute();

But I receive the error

Drupal\Core\Entity\Query\QueryException: Invalid specifier 'title' in Drupal\Core\Entity\Query\Sql\Tables->addField()

Is it possible to sort a node query by a field inside a referenced node?

Sure but you probably want to sort and not use a condition for this api.drupal.org/api/drupal/… — tenken
– tenken, Commented Apr 4, 2017 at 17:00
@tenken whoops, that was a typo, thanks, I went ahead and made the update — Amy
– Amy, Commented Apr 4, 2017 at 18:01

tenken · Accepted Answer · 2017-04-04 17:04:41Z

I believe you want something like below. Note that this isn't really a database query at this level but an Entity Query:

$event_nids = \Drupal::entityQuery('node') ->condition('type', 'my_content_type') ->sort('field_referenced_node.entity.title', ASC) ->execute();

1 Answer 1