1
0
-1
1 answer
- 10-1
There is no tabled named "dir_users"
The table that stores which user in which group is "dir_user_group"
Try
select * from dir_user join dir_user_group where dir_user.id = dir_user_group.userId
Add your comment...
There is no tabled named "dir_users"
The table that stores which user in which group is "dir_user_group"
Try
select * from dir_user join dir_user_group where dir_user.id = dir_user_group.userId
Hi everyone,
I am trying to implement a custom SQL Query for my datalist with the JDBC Datalist Binder
I would like to only include users of a certain group but I don't have the enterprise-edition, so I can not use the hash-variable user.groups.id.
So what I'm trying to do is to join the table dir_user with dir_users where one can find the column #users.group.GROUP_ID.username# (Hash Variable#UsersHashVariable) but when I try to add the users hash-variable to my SQL Query I get this error: Fail to retrieve column list. Please check your configuration.
This is my query:
SELECT
user.username, user.lastName, user.firstName
FROM
dir_user AS user, dir_users AS users
With JOIN I tried this, but I got the same error:
SELECT
user.username, user.lastName, user.firstName
FROM
dir_user AS user
INNER JOIN dir_users ON user.username = dir_users.group.myGroupID.username
(I am not completely sure if the JOIN is right but I think I can figure it out if the error is fixed)
Thanks for your help