[development] Sort nodes based on their position on a menu (views_handler_sort_menu_hierarchy?)

[Andrew Fowlston]

Thanks Ken,

> The issue is that you cannot actually run a database query to sort the
> menu correctly, due to the nesting of children.

Yeah, I understand from this page (http://drupal.org/node/141866) that 'We need to sort each subtree by weight and title in PHP' which I think is what you're referring to? I don't know how Views works internally - does that restriction of needing both a db query and some PHP post-processing make it a pain to implement as a view?

> You might also try http://drupal.org/project/menu_node_views

Thanks, I'll do that.

Andy

. . . . . . . 
Andy Fowlston
+44 (0)20 8747 5068
andrew at pedalo.co.uk
Skype: andy.pedalo
www.pedalo.co.uk

This email is intended only for the above named addressee/s. This email may be confidential or legally privileged. If you have received this email and you are not a named addressee, you must not use, copy, distribute or disclose the email or any part of its contents or take any action in reliance on it. If you have received this email in error, please email the sender by replying to this message and delete it from your system. All reasonable precautions have been taken to ensure no viruses are present in this email. 

pedalo limited cannot accept responsibility for loss or damage arising from the use of this email or attachments and recommends that you subject these to your virus checking procedures prior to use. Any views or opinions presented are solely those of the author and not necessarily those of Pedalo Limited

Please consider the environment before printing this email

-----Original Message-----
From: development-bounces at drupal.org [mailto:development-bounces at drupal.org] On Behalf Of Ken Rickard
Sent: 04 January 2011 16:40
To: development at drupal.org
Subject: Re: [development] Sort nodes based on their position on a menu (views_handler_sort_menu_hierarchy?)

The issue is that you cannot actually run a database query to sort the
menu correctly, due to the nesting of children. But you can come
close. (You also can't run a clean JOIN from {node} to {menu_links}
without either a SQL calculation or a helper module.
	
You might also try http://drupal.org/project/menu_node_views, which is
the project that tries to consolidate work on Menu integration for
Views, though it could use some work.  If nothing else, you can likely
steal its sort handler.