1) I have a node “parent”
2) I have 2 nodes “child”
3) Each child has a reference field (filled with a reference to the node “parent”)
Now, I’m trying to create a list with the Views module.
First problem: This list is a list of “parent” nodes AND should include a column with the following result: COUNT(child with a reference to the parent).
Second problem: The count result should include only published children.
Example 1 with 2 children published (2 children have a reference to the parent):
Title of parent node | 2
Example 2 with 1 child published (2 children have a reference to the parent):
Title of parent node | 1
Sorry if it’s not totally clear, it’s hard to explain
Above all of this, if the result could be sortable it will be a good news but I don’t think it will be possible…