By scott859 on

Greetings,

I have created a view that is displayed (formatted) in a table. One of the table columns (fields) is a CCK Node Reference field. I would like to be able to sort that column, but by default, Views does not allow sorting of CCK Node Reference fields.

If anyone has a solution to this, I would appreciate your insight and help.

Thanks in advance.

Scott

⋅ Categories: Drupal 6.x

Comments

scott859’s picture

scott859 commented

I have found a solution to this and wanted to post it here in case anyone is faced with the same issue.

It requires the Dev version of Views at this point - here is the post: http://drupal.org/node/859368

Scott

vj’s picture

vj commented

hello,

Same problem for me..
1. so I added a relationship to that reference field.

2. Add a field "node title" with relationship to that reference field.

3. Now goto table setting u can see the sort by option for that field.

Hope this will help you rather to choose a new dev module.

svnindia’s picture

svnindia commented

how can we pass the values using views_get_view

$view->add_item($display, 'sort', 'node', 'title',array('order' => $sort));

Thanks in advance,
SVN

svnindia

scott859’s picture

scott859 commented

@Vj,

Thanks so much! Yes, that is a much better solution in my case.

Scott