Fetching more than id's of an entity using EntityFieldQuery

Question

I have just learnt how to use the EntityFieldQuery to make simple queries.

In the example below I fetch all the comment id's for the logged-in-user.

global $user;

$query = new EntityFieldQuery();
$query->entityCondition('entity_type', 'comment')
->propertyCondition('uid', $user->uid)
->addMetaData('account', user_load(1));
$result = $query->execute();
var_dump($result);
$cids = array();
if (isset($result['comment']))
$cids = array_keys($result['comment']);

Is it possible to get the comment body and the node id where that comment belongs using the way i use above?

Answer 1

No - you need to load the comment (comment_load()) to get property and field data attached to the results of an EFQ - its job is to load IDs only.

An alternative would be mikeytown2's EntityFieldQueryExtra class, which does allow you to attach field and property data to the results of the query.

Answer 2

To fetch a type of entity you have to add the entity_type condition to it.

You have to fetch nodes, so the code for it will be as follows:

$query = new EntityFieldQuery();
$query->entityCondition('entity_type', 'node');

The entity condition is set using the function entityCondition in which you can set the entity type as node. Once if you have set the entity condition, you can execute the query. The node ids are returned in an array in the node key of the result. The complete code to display the nodes will be as follows:

$query = new EntityFieldQuery();
    $query
    ->entityCondition('entity_type', 'node');


    $result = $query->execute();
    $nodes = array();
    if (isset($result['node'])) {
      $nids = array_keys($result['node']);
      $nodes = node_load_multiple($nids);
    }

    $list = array();
    foreach ($nodes as $node) {
      $options = array('absolute' => TRUE);
      $url = url('node/' . $node->nid, $options);
      $list[] = '<a href='.$url.'>'.$node->title.'</a>';
    }

    $theme_args = array('items' => $list, 'type' => 'ol');
    $content = theme('item_list', $theme_args);

    $block = array(
      'subject' => t('A block to display results from entityquery'),
      'content' => $content,
    );
    return $block;

Thank you.