Hierarchical db query

Question

How I can do this recursive query into CCv6? Thanks.

select  aid,
        name,
        parent_aid 
from    (select * from table
         order by parent_aid, name) tree,
        (select @pv := '$this->data("filter")') initialisation
where   find_in_set(parent_aid, @pv)
and     length(@pv := concat(@pv, ',', aid))

Max_admin · Accepted Answer

This is not supported by default!

Forums

Hierarchical db query