pandolfaccia
Member
Hi,
I insert a databasejoin in my list, whit the J! usergroups. I'd like to filter the result of the join, selecting only the groups that have a specific group as parent.
i used the data/where tab and inserted in the "Joins where and/or order by statement (SQL)" field this query:
WHERE `joskf__usergroups`.`parent_id` = 21
but after that, when i try to add a new entry, the form hang loading.
what am i doing wrong?
Thanks
alberto
I insert a databasejoin in my list, whit the J! usergroups. I'd like to filter the result of the join, selecting only the groups that have a specific group as parent.
i used the data/where tab and inserted in the "Joins where and/or order by statement (SQL)" field this query:
WHERE `joskf__usergroups`.`parent_id` = 21
but after that, when i try to add a new entry, the form hang loading.
what am i doing wrong?
Thanks
alberto