I created a TV with combobox.
I wish to generate values with a chunk. Inside the chunk there is GETRESOURCE Snippet call.
but snippet isnt processed.
We could do with @SELECT call, but ich will generate a dropdownlist with treepath for description text.
now I am searching for a solution.
I tried also via sql
WITH RECURSIVE category_path (id, path) AS ( SELECT id, pagetitle as path FROM am_site_content WHERE parent = 48 and isfolder = 1 and class_key='CollectionContainer' UNION ALL SELECT c.id, CONCAT(cp.path, ' > ', c.pagetitle) FROM category_path AS cp JOIN am_site_content AS c ON cp.id = c.parent ) SELECT * FROM category_path ORDER BY path;
but only @SELECT bindings possible
thanks for feedback and tipps.