Hello,
I have problem with SQL in Quick Report. I write this SQL query:
SELECT CASE
WHEN COUNT(CASE WHEN parent_part_status <> 'B' THEN 1 END) = 0 THEN 0
ELSE NULL
END AS result
FROM MANUF_STRUCTURE
WHERE component_part = :component_part
GROUP BY component_part; this retrieves nothing in both comp parts)
SELECT CASE
WHEN COUNT(CASE WHEN parent_part_status <> 'B' THEN 1 END) = 0 THEN 0
ELSE NULL
END AS result
FROM MANUF_STRUCTURE
WHERE component_part = ‘U010805’
GROUP BY component_part; (retrieves 0, which is good)
SELECT CASE
WHEN COUNT(CASE WHEN parent_part_status <> 'B' THEN 1 END) = 0 THEN 0
ELSE NULL
END AS result
FROM MANUF_STRUCTURE
WHERE component_part = ‘U010751’
GROUP BY component_part; (retrieves nothing, which is good)
I am using tab → component where used, every component part has some part numbers and every part number has parent_part_status, which belongs in 2 categories - B,A (blocked, active). My problem is when i want to input in “:component_part” item U010805, which has 4 part no and every part_no has parent_part_status = B => in this case I want to display in new columns “Has superior part” 0. And I have second component part U010751 which has 4 part no with parent_part_status = B and two part no with parent_part_status = A, in this case i want to display nothing (NULL value). But problem is when I input this dynamically in “:component_part”, in both case returns nothing.
I also tried to find column Buildable Structures Only in SQL, but I cant find it, so I dont know if this component is working only with parent_part_status
How can I solve this?
Thanks
