Using EntityFieldQuery with Address Field

Question

I have a custom content type with a postal_address field provided by the module addressfield. postal_address fields are one field in the custom content type. This one field is comprised of many subfields like: country, name_line, and postal_code.

How can the core function EntityFieldQuery be used to retrieve nodes of my custom content type based on their postal code value (a subfield of the postal_address field)?

Specifically, I do not know what to put in the code below instead of the text: what_goes_here:

$query  =  new EntityFieldQuery();

$entities  =  $query->entityCondition( 'entity_type', 'node' )
  ->propertyCondition( 'status', 1)
  ->propertyCondition( 'type', 'consumer_store' )
  ->fieldCondition( 'what_goes_here', 'value', $postal_codes )
  ->execute();

Answer 1

Although Addressfield can be extended, the standard columns like zip code are normal field columns and live in field storage (see addressfield_field_schema()).

In your case you want the postal_code column:

$query  =  new EntityFieldQuery();

$entities  =  $query->entityCondition( 'entity_type', 'node' )
  ->propertyCondition( 'status', 1)
  ->propertyCondition( 'type', 'consumer_store' )
  ->fieldCondition( 'field_postal_address', 'postal_code', $postal_codes )
  ->execute();