I have two content types. Let's call them "A" and "B".
A has nodes with field_cost
B has nodes with field_total_cost
Content type A has a field_costumer which is referenced to the entity of Content B.
Which means, the title of Content B node = value of field_costumer of Node A.
They have Many-to-one relationship. In the picture below, Node x has two nodes attached to it and so does Node y.
I wanted to calculate the total number of nodes of content type A that are attached to a particular node of content type B (say node X).
I was able to accomplish:
$type = 'A'; $nid = $entity->nid; $query = new EntityFieldQuery; $result = $query ->entityCondition('entity_type', 'node') ->propertyCondition('status', 1) ->propertyCondition('type', $type) ->fieldCondition('field_customer', 'target_id', $nid ,'=') ->execute(); $cant = count($result['node']); $entity_field['value'] = $cant;
I got the desired result which was:
Now here is the problem: I want to sum a particular column(field) of content type A nodes which are connected to Node X.
I am using computed field drupal 7 module.
I tried different ways, for example, using field_cost_value and passed it as the column name instead of usual entity reference's target_id. I created a variable and tried to load the node of the content type A and passing it to result as $result['node']['field_cost'] but failed.
I am out of my stretch here. Help.