SQL filter on database join element

[tmntmn]

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

 

[troester]

Try
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)
)

 

[tmntmn]

Hi Troester

Of course

Thx

Thomas