Display number of times content is referenced in content

Question

How would I go about implementing the following content types + fields

• Parent
  • Name
  • Description
  • Other fields (e.g. location, date)
  • Number of children
• Child
  • Name
  • Description
  • Other fields (e.g. location, date)
  • Parents (entity reference)

Children can have multiple parents.

Basically what I want to do is to create a new Child and "tag" a Parent in it. A View with a list of Parents would then display something like "[Parent Name] has x Children" for each Parent.

I'm very new to Drupal so if I'm going about this completely the wrong way, please let me know!

Answer 1

This video series helped me an infinite amount: http://vimeo.com/33251051, http://vimeo.com/33252553.

1. Make sure Child has an entity reference to Parent.
2. Create a new view
3. In Filter Criteria, add a new Type (= Parent)
4. In Advanced>Other, set Aggregation to YES
5. In Advanced>Relationships, add a new relationship for "A bridge to the Content entity that is referencing Content via field_parent" where field_parent is your entity reference. Call this "Parents"
6. In Fields, add Content: Title and when prompted set its Aggregation type to Group results together
7. In Fields, add Field: Parents and when prompted set its Aggregation type to COUNT (Distinct)
8. Ta-da

Answer 2

You can use combination of Taxonomy and Content Types... Please follow below steps to complete the functionality....

1. Create a vocabulary called parent.
2. Add parent terms -- You can give term name & description.
3. Create a Content Type Called Children
4. Add Term Reference field and reference to Parent Vocabulary.
5. For above field give number of values as Unlimited so that Children can have multiple parents.
6. Use views module to create a new view with base table as taxonomy and show list of parent terms with number of nodes tagged using views aggregation functions.

It makes sense to create a content Type for parent also if you have many parents...

In views you can add a entity reference relationship and use aggregation setting and check you can able to pull off what you are trying to achieve i guess...

Optionally check this module if it solves the issue drupal.org/project/nodereference_count....

If nothing works you can use views php module and write a single query to achieve the functionality...

Hope it resolves your problem.