By martinkong on

Started playing around with the Views module, it's simply amazing how flexible it is. I'm surprised to find out it doesn't have filter for noderefernce field. Any reason for not having that? Is there a patch out there that addes this functionality?

Thanks!

Comments

crandell’s picture

crandell commented

I need a patch like this too. I'm looking to filter a view to show only nodes that have a value in a nodereference field. I need something that functions the "Taxonomy: Vocabulary Name" filter, but that shows nodereference fields.

biohabit’s picture

biohabit commented

I was hoping that I was just missing something. I'll see if there is a feature request already in place.

crandell’s picture

crandell commented

I solved my problem, but I can't find the post that helped me figure it out now, so I'll try to describe my solution.

I wanted to create a block that listed every node that refered to the node a reader was currently reading. The framework is a blog that allows writers to post blogs in a neighborhood -- each neighborhood is a node -- and when a reader goes to a neighborhood, they can see all blog posts in that neighborhood. I used nodereference over taxonomy because it allows users to easily add new neighborhoods, and allows for basic stats for each neighborhood.

To create the blocks, I made a new block view, with an argument Node Reference: (field). Then to make it work, I had to add this text to the Argument Code (per the post I can't find now):

if ($type == 'block' && arg(0) == 'node' && is_numeric(arg(1))) {
$nid = arg(1);
//$node = node_load($nid);
$args[] = $nid;
}
return $args;

I then filtered by taxonomy and node type. The result is that any new neighborhood node will have a block showing posts under each taxonomy term in that neighborhood.

Anonymous’s picture

Anonymous (not verified) commented

I'm not sure to understand clearly how you made it work. Could you please give me more details on how to create the block ?

Thank you :)

biohabit’s picture

biohabit commented

Any chance you could provide an export of your view?

crandell’s picture

crandell commented

I used CCK nodereference.

I added a nodereference field to the blog content type that refers to my custom content type "Neighborhood." In Drupal 5, you can add custom field to the blog -- in 4 I had to create a custom content type for my blog.

With the nodereference field, I can related blog posts to a Neighborhood.

I then created a custom view, with an argument "Node Reference: Neighborhood (field_neighborhood)" -- this would obviously not say Neighborhood in your View. Then in argument handling code, I entered the following code (not sure where I found this before, but it worked):

if ($type == 'block' && arg(0) == 'node' && is_numeric(arg(1))) {
$nid = arg(1);
//$node = node_load($nid);
$args[] = $nid;
}
return $args;


Here's the view export:

  $view = new stdClass();
  $view->name = 'Related_Blogs';
  $view->description = '';
  $view->access = array (
  0 => '1',
  1 => '2',
);
  $view->view_args_php = 'if ($type == \'block\' && arg(0) == \'node\' && is_numeric(arg(1))) {
$nid = arg(1);
//$node = node_load($nid);
$args[] = $nid;
}
return $args;';
  $view->page = TRUE;
  $view->page_title = '';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'teaser';
  $view->url = '';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->block = TRUE;
  $view->block_title = '';
  $view->block_header = '';
  $view->block_header_format = '1';
  $view->block_footer = '';
  $view->block_footer_format = '1';
  $view->block_empty = '';
  $view->block_empty_format = '1';
  $view->block_type = 'teaser';
  $view->nodes_per_block = '5';
  $view->block_more = TRUE;
  $view->block_use_page_header = FALSE;
  $view->block_use_page_footer = FALSE;
  $view->block_use_page_empty = FALSE;
  $view->sort = array (
  );
  $view->argument = array (
    array (
      'type' => 'content: field_neighborhood',
      'argdefault' => '1',
      'title' => '',
      'options' => '',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
  );
  $view->field = array (
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'blog',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node);
  $views[$view->name] = $view;
faunapolis’s picture

faunapolis commented

Hi,

Excellent code, it worked perfectly.

I want to do exactly the opposite, that is, I have a node which references to other nodes (using the node reference CCK field), and I want to list fields from those nodes (that are referenced) using views.

Thank you very much in advance

http://www.faunapolis.org/

Bencoon’s picture

Bencoon commented

I'm assuming you mean you want to display the view block on the same custom content that holds the nodereference field? If so, well, I'm trying to figure that out too. There's a couple of cck modules that look like they might do the trick, but they're all currently dev. :/

patchak’s picture

patchak commented

Hey there I need exactly the same thing... To be able to list fields from nodes that are referenced from the 'current' node...

Have you found a solution for this? I'm using drupal 5... Thanks

Patchak

Création de sites web
Actualité informatique

amariotti’s picture

amariotti commented

Check the bottom of this post:

http://drupal.org/node/86410#comment-1060891

saltcod’s picture

saltcod commented

sub

amitaibu’s picture

amitaibu
Primary language Hebrew
Location Israel
commented

My case is a bit different, but I'll use u're exmaple:
Neighborhood node has a node reference (with mutli values) to the Blog node.

How can I show in a block all the Blog nodes that are referenced by Neighborhood node?

Cheers,
Amitai

raspberryman’s picture

raspberryman commented

Amitaibu,

I had the same issue. On node/Z, I wanted to display a View listing of all the nodes that referred to it. So if Node/A, Node/B, and Node/C all had a nodereference to node/Z, then on Node/Z I wanted to display those three in a View list.

I did this by creating my own $view object, with this code for the filter:

  $view->filter = array (
    array (
      'tablename' => 'node_data_field_featured',
      'field' => 'field_featured_nid_default',
      'operator' => '=',
      'options' => '',
      'value' => arg(1),
    ),
  );
amitaibu’s picture

amitaibu
Primary language Hebrew
Location Israel
commented

Thanks for the info!

---
gizra.com - where cool software developers meet geek fashion designers

faunapolis’s picture

faunapolis commented

interested in this

http://www.faunapolis.org/

summit’s picture

summit commented

Subscribing, greetings, Martijn

amariotti’s picture

amariotti commented

I blogged about this a little while ago. Here's the link if anyone's interested:

http://amariotti.com/blog/reverse-nodereference-block