Because field_sql_storage_field_storage_query uses INNER JOINs instead of LEFT JOINs, it is not possible to use EntityFieldQuery to query for entities without a value for a specific field.

Comments

bojanz’s picture

bojanz CreditAttribution: bojanz commented

Following.

supertwang’s picture

supertwang CreditAttribution: supertwang commented

following

pbuyle’s picture

pbuyle CreditAttribution: pbuyle commented

The INNER JOINs are actually done by field_sql_storage_field_storage_query. I don't known if any other field storage backend support NULL in field condition or not.

The INNER JOINs in field_sql_storage_field_storage_query are also the cause of #1240566: In field_sql_storage_field_storage_query, any condition on a field's column excludes entities with a NULL value for this column

pbuyle’s picture

pbuyle CreditAttribution: pbuyle commented
Status: Active » Closed (duplicate)

The issue was already reported in #1226622: EntityFieldQuery doesn't support query for entities without a value for a specific field

grota’s picture

grota CreditAttribution: grota commented

For a workaround see #1157006.

grota’s picture

grota CreditAttribution: grota commented
Issue summary: View changes

The INNER JOINs are actually done by field_sql_storage_field_storage_query.