Hi all
Finally upgraded to joomla 3 and fabrik 3.1.x
So I have to renew my filtering on DB joins.
Trying to filter the database join element dropdown as described in the wiki.
Works OK with only one usergroup. However when I try to add additional usergroups the result is not filteret anymore.
Can't seem to get the right syntax here:
WHERE {thistable}.`username`
IN ( SELECT j25_users.username FROM j25_users, j25_user_usergroup_map
WHERE j25_users.id = j25_user_usergroup_map.user_id
AND j25_user_usergroup_map.group_id = 29 OR
j25_user_usergroup_map.group_id = 15
)
Any help are appreciated.
Best regards
Thomas
Finally upgraded to joomla 3 and fabrik 3.1.x
So I have to renew my filtering on DB joins.
Trying to filter the database join element dropdown as described in the wiki.
Works OK with only one usergroup. However when I try to add additional usergroups the result is not filteret anymore.
Can't seem to get the right syntax here:
WHERE {thistable}.`username`
IN ( SELECT j25_users.username FROM j25_users, j25_user_usergroup_map
WHERE j25_users.id = j25_user_usergroup_map.user_id
AND j25_user_usergroup_map.group_id = 29 OR
j25_user_usergroup_map.group_id = 15
)
Any help are appreciated.
Best regards
Thomas