Hi folks
I am using Select Dynamic Cascade version 1.3.2
I can get result with Query = Construction, but this example of Query = Free has no effect:
START FIELD
Behaviour:
START<br>
SQL Query:
SELECT a.name AS id, a.name AS text FROM #__users AS a INNER JOIN #__user_usergroup_map AS b ON a.id = b.user_id WHERE b.group_id = 10<br>
Options Value:
a.name
I end up with values, but it does not cascade....
END FIELD
Behaviour:
END
SQL Query:
SELECT id AS text, id AS value FROM #__users WHERE name = [parent]
No cascade....
Any ideas?
Is it me or maybe the version is too old now? etc
It seems that this breaks it
WHERE name = [parent]
... hmm...
If I leave it out all is good.... confusing!!
you can find some details here: https://www.seblod.com/community/forums/fields-plug-ins/free-sql-query-in-cascad-select-dynamic
Hi again.
I thought I would work it through myself, then had other things to attend to, now back on this:
I have read the link above many many many tomes before and after link was referenced.
Can not for the life of me work out what I am doing wrong.
FIELD 1:
SELECT a.name AS value, a.name AS text FROM #__users AS a INNER JOIN #__user_usergroup_map AS b ON b.user_id = a.id WHERE b.group_id = 10
OPTIONS VALUE: a.name
This produces my list of users. Nice.
FIELD 2:
SELECT a.id AS value, a.id AS text FROM #__users AS a WHERE a.name = [parent]
PARENT: a.name
Is it OPTIONS VALUE?
Is it PARENT?
Out of ideas except for my trusty sledgehammer