Views 3 - Using a node field value as filter criteria

Posted by simetau on December 11, 2012 at 9:07pm

Hi,

I have spent hours trying to figure this out, hoping that one of you can point me in the right direction and show me the error of my ways.

I have a content type called "category location page" which has a few fields:
title: text
body: text
category: entity ref
location: entity ref

I want to be able to create a view as a block that shows the titles (linked) for all category location pages that has the same category field value as that of the current node.

I hope this makes sense, it seems that I it would have been preferable to use taxonomy terms instead of entity references but this is a retro-fit want.

Thanks for any help you can offer.

Comments

This may be what you want:

Posted by nateman332 on December 11, 2012 at 9:20pm

This may be what you want: https://drupal.org/node/1841936 , I was trying to do the same thing on drupal 6x.

Saving the internet, one file at a time.
If I helped, Pay it forward or give me a cookie ;)

Thanks for that info but

Posted by simetau on December 13, 2012 at 3:52pm

Thanks for that info but unless I am not implementing it correctly then this only works when the block is on the category (parent) node.

What I want is to have the block on the location (child) node and have it display all of the other locations (siblings) - if that makes sense...

On the location node I want a block to display all of the other locations that use the same category as the current location node (the category is referenced via an entity reference field in the location content type).

Any further help would be greatly appreciated.

Thanks!