Using entity reference to display all nodes that reference another

Posted by surfgatinho on January 14, 2013 at 4:01pm

I'm really struggling to get my head around how to replicate the basic functionality of an existing site I'm trying to port over to Drupal.

Basically the main pages are locations. These are within regions that are within countries that are within continents:
continent->country->region->location (each level has associated descriptions)

The original site just has a DB with foreign keys in the lower level referencing the ID of the parent - e.g. country will have a continent field referencing the ID of the relevant continent.

I've had some success importing the data and setting up entity references to reflect the above structure. So I now have a country content type with a continent entity reference field pointing to the relevant continent.

What I would like to be able to do is create a view for each continent which lists all the countries below it. And the same for countries and regions etc. These would also be dynamically accessible via the URL, e.g. mysite.com/europe/france/paris

Any suggestions on what I need to do would be hugely appreciated.

Thanks,
Chris

Comments

_

Posted by WorldFallz on January 14, 2013 at 5:35pm

One way to do it is to simply create a listing of all countries-- the entityereference field will display the title of the referenced field. Then just group by the entityreference field. You can also add a relationship for the referenced entity which you can use to access any of the other fields besides the title.

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}

Thanks for the help. I've now

Posted by surfgatinho on January 14, 2013 at 8:19pm

Thanks for the help.

I've now got to the point where I can get all the countries within a continent by sending the node id of the continent to the view as an argument in the URL.
I guess that's a start. However, I really need to be able to access the referenced entity by one of the other fields such as 'name'. Can this be done using entity reference?

_

Posted by WorldFallz on January 14, 2013 at 8:43pm

You can also add a relationship for the referenced entity which you can use to access any of the other fields besides the title.

;-)

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}

Thanks. Yep, good advice.

Posted by surfgatinho on January 14, 2013 at 8:47pm

Thanks. Yep, good advice.

Didn't understand what you meant until I'd virtually tripped over it myself.

_

Posted by WorldFallz on January 14, 2013 at 10:50pm

no worries... it's easy enough to miss in the million views options, lol.

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}