entityfieldquery, return several results

Question

I want get several entries of database. Im a entityfieldquery novice and I misunderstand how I do for get several results who contain certain fields (here, the fields that interest me are : delta, field_top_value and field_top_revision).

By example, I try this code :

$query = new EntityFieldQuery();
$query
    ->entityCondition('entity_id',$nid_device)
    ->entityCondition('entity_type','node');
$result = $query->execute();
dpm($result); //show just one only node...but I would like get the five entries, with field "delta, field_top_value and field_top_revision_id"

I "tried" to read the documentation, but my english reading isn't very good, and I don't find example for my case..

Thanks for help !

Answer 1

Whenever you load data by entityfieldquery(), then it will return you everything in term of node.

1. Here entity_id from table and nid of node is same
2. vid parameter in node is same as revision_id in the table
3. delta specifies multiple value saved w.r.t a particular field e.g. a field category with table field_data_field_category has multiple values testcategory1 ,testcategory2.

Then it will saved in the database as delta 0 for testcategory1 and 1 for testcategory2.

And when it will be returned in node all values are assembled to show in the particular field w.r.t which it belongs in the form of array.

Also you can load the node data separately by node_load() function by passing entity_id/node id to load all data w.r.t that particular node in assembled mode.

Answer 2

The table in your screenshot is a field table. It stores field data for entities, for both multiple and single cardinality fields.

When you use an EntityFieldQuery, you're querying for entities, not fields. It wouldn't make sense for you to receive data for anything else.

The connection you need to encourage your brain to make is that the fields are attached to the entities. So, if you want to know about multiple field values for a node, you just need to go and get them:

// Keep track of the delta, you mentioned you wanted it...
$delta = 0;
foreach (field_get_items('node', $node, 'field_foo') as $item) {
  $field_value = $item['value'];

  $delta++;
}

If that isn't what you're looking for, then EntityFieldQuery probably isn't the tool for the job. If that's the case, and you're using MySQL as the storage backend for fields, I'd recommend manually querying the field_data_field_foo table to get what you're after directly.

Answer 3

Your code is looking for a specific node with a specific nid. nid or entity_id is a unique key. Use different properties to query your entities.