Hi,
I want to create a SuiteQL that filters out all classes where either its direct parent is inactive or any of the parents up the hierarchy are inactive.
I thought I could solve this by using connect by prior in combination with SYS_CONNECT_BY_PATH but I can't get it to work. Do you have any tips?
SELECT id, name, parent, SYS_CONNECT_BY_PATH(isinactive,'_') as path
FROM classification
WHERE SYS_CONNECT_BY_PATH(isinactive,'_') not like('%T%')
CONNECT BY PRIOR id = parent