Contrib.social

There's no way to LEFT JOIN with an EntityFieldQuery.

Open on Drupal.org →
Created on 10 February 2011, over 14 years ago
Updated 17 April 2025, 4 months ago

I have an EntityFieldQuery that uses tableSort() including a header for an integer type field. Before any click sorting, the table displays fine, inclduing some nodes which have no value for the integer field. When I click to sort by the integer field, nodes without a value are excluded in the new results.

This does NOT occur for text fields when there is no string.

Here's an example of my code. The integer field is 'field_year_implemented':

  $header = array(
    'title' => array('field' => 'title', 'type' => 'property', 'data' => 'Program Name', 'sort' => 'asc', 'specifier' => 'title'),
    'field_year_implemented' => array('field' => 'field_year_implemented', 'type' => 'field', 'data' => 'Year', 'specifier' => array('field' => 'field_year_implemented', 'column' => 'value')),
  );
    $query = new EntityFieldQuery();
    $query->entityCondition('entity_type', 'node')
      ->entityCondition('bundle', $nodetype)
      ->fieldCondition('field_nodereference', 'nid', $id)
      ->tableSort($header)
      ;

    $result = $query->execute();
✨ Feature request
Status

Postponed: needs info

Version

11.0 🔥

Component

entity system

Created by

🇺🇸United States matt2000

Live updates comments and jobs are added and updated live.
  • stale-issue-cleanup

    To track issues in the developing policy for closing stale issues, [Policy, no patch] closing older issues

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment 4 months ago →
    🇺🇸United States smustgrave

    Thank you for sharing your idea for improving Drupal.

    We are working to decide if this proposal meets the Criteria for evaluating proposed changes. There hasn't been any discussion here for over 8 years which suggests that this has either been implemented or there is no community support. Your thoughts on this will allow a decision to be made.

    Since we need more information to move forward with this issue, the status is now Postponed (maintainer needs more info). If we don't receive additional information to help with the issue, it may be closed after three months.

    Thanks!

  • Comment 7 days ago →
    🇺🇸United States smustgrave

    Wanted to bump 1 more time before closing.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024