Active
Project:
Node Hierarchy
Version:
6.x-2.1
Component:
Views Integration
Priority:
Major
Category:
Bug report
Assigned:
Reporter:
Created:
16 Feb 2012 at 09:59 UTC
Updated:
16 Feb 2012 at 09:59 UTC
i have nodes:
parents without cck values and ansestor with cck values
i want to create a view. It must show all parent nodes with ancestor nodes cck values fit within my range.
Therefore:
1. i set a relationship: "Ansestor Node ID"
2. Add relationship filter: "cck value" (price)
The views generate the following query:
SELECT node.title AS node_title,
node.nid AS nid,
node.language AS node_language
FROM node node
LEFT JOIN nodehierarchy_menu_links nodehierarchy_menu_links ON node.nid = nodehierarchy_menu_links.nid
LEFT JOIN menu_links nh_menu_links ON nodehierarchy_menu_links.mlid = nh_menu_links.mlid
LEFT JOIN nodehierarchy_menu_links nh_ancestor ON (nh_menu_links.p1 = nh_ancestor.mlid OR nh_menu_links.p2 = nh_ancestor.mlid OR nh_menu_links.p3 = nh_ancestor.mlid OR nh_menu_links.p4 = nh_ancestor.mlid OR nh_menu_links.p5 = nh_ancestor.mlid OR nh_menu_links.p6 = nh_ancestor.mlid OR nh_menu_links.p7 = nh_ancestor.mlid OR nh_menu_links.p8 = nh_ancestor.mlid) AND nh_menu_links.mlid != nh_ancestor.mlid
LEFT JOIN node node_nh_ancestor ON nh_ancestor.nid = node_nh_ancestor.nid
LEFT JOIN content_type_sell node_nh_ancestor_node_data_field_price ON node_nh_ancestor.vid = node_nh_ancestor_node_data_field_price.vid
WHERE node_nh_ancestor_node_data_field_price.field_price_value <= 15000 AND this query does't return any results.