Sort nodes by weight of taxonomy term attached to field

Matt

1/16/24, 8:40 PM

In a query for nodes I'm trying to sort the nodes by the weight of a taxonomy term attached to one of the node fields.

Here is how my query is built

    $node_storage = \Drupal::entityTypeManager()
      ->getStorage('node');
    $my_query = $node_storage
      ->getQuery()
      ->accessCheck(FALSE)
      ->condition('type', 'my_content_type')
      ->condition('status', NodeInterface::PUBLISHED)
      ->condition('field_my_custom_field', $this->id());

It's the sorting part where I get stuck. Here's my attempt

    $my_query->leftJoin('taxonomy_term_field_data', 'td', 'td.tid = node_field_data.field_my_custom_field.target_id')
    ->orderBy('td.weight', 'ASC')
    ->execute();

By leftJoin is not available. I've looked at https://api.drupal.org/api/drupal/core%21lib%21Drupal%21Core%21Entity%21Query%21Sql%21Query.php/class/Query/9.0.x and I do see that sqlQuery is a property on the Query object that you can perform leftJoin on it but sqlQuery is a protected property.

Is sorting by this possible?

109

1 + 0

taxonomy-terms

Score:1

Drupal

Matt

1/17/24, 3:19 PM

I was able to sort by the taxonomy weight with this

->sort('field_my_custom_field.entity.weight','DESC');

+ 0

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Sort nodes by weight of taxonomy term attached to field

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.