Hello,
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.
bye
Chris