Quantcast

Sorting of mm views

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Sorting of mm views

grahamtk
Hi!
I have a news slider that is a view on this page:
http://www.nmbu.no/forskning/tema/mat

it is filtered by a contextual filter (MM nodes on MM page) sorted by mm
page weight asc and node weight asc.

Should it not be same order as the nodes appear on the mm page from where it
is fetched?
http://www.nmbu.no/forskning/tema/mat/nyheter
currently they are not. The nodes appear on more than one page, could that
affect the sorting?

this is the sql produced by views:

SELECT DISTINCT node.nid AS nid, node.title AS node_title, mm_tree.sort_idx
AS mm_tree_sort_idx, mm_node_reorder.weight AS mm_node_reorder_weight,
'node' AS field_data_field_umb_ingressbilde_node_entity_type, 'node' AS
field_data_field_umb_article_ingress_node_entity_type, COUNT(DISTINCT
node.nid) AS nid_1
FROM
{node} node
INNER JOIN {mm_node2tree} mm_node2tree ON node.nid = mm_node2tree.nid
LEFT JOIN {mm_tree} mm_tree ON mm_node2tree.mmtid = mm_tree.mmtid
LEFT JOIN {mm_node_reorder} mm_node_reorder ON mm_node2tree.nid =
mm_node_reorder.nid
WHERE (( (mm_node2tree.mmtid = '836') )AND(( (node.type IN  ('umb_article'))
AND (node.status = '1') )))
GROUP BY nid, field_data_field_umb_ingressbilde_node_entity_type,
field_data_field_umb_article_ingress_node_entity_type
ORDER BY mm_tree_sort_idx ASC, mm_node_reorder_weight ASC
LIMIT 5 OFFSET 0


Best,
√ėyvind Graham



--
View this message in context: http://monster-menus.2910260.n2.nabble.com/Sorting-of-mm-views-tp7573001.html
Sent from the Monster Menus mailing list archive at Nabble.com.

---
You are currently subscribed to monster_menus as: [hidden email].
To unsubscribe click here: http://lists.middlebury.edu/u?id=685503.6b071f880fe6a965a128164e6d09ea81&n=T&l=monster_menus&o=708439
or send a blank email to [hidden email]
Loading...