Buy Now
Sign in

Hierarchical db query

cesarvelame , February 01 2021, 16:30
C
cesarvelame 57
February 01 2021, 16:30 #395807
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))
admin 33
February 03 2021, 01:20 #395819
 Answer
This is not supported by default!