Hierarchical db query

Execute a hierarchical database query in ChronoForms v6.

Overview

The platform does not natively support the required recursive SQL query structure.
You must implement a custom solution, as the standard query builder does not include this functionality.

Answered
Connectivity v6
ce cesarvelame 01 Feb, 2021
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 Max_admin 03 Feb, 2021
Answer
This is not supported by default!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.