Reports in Connection with Teams

[enrikm]

Good afternoon all,

I currently have the Teams module up and running. However when using ZuckerReports, this overrules the Teams module, returning all records that the current user isn't suppose to see.

My question therefore is, is there any way we can link the reports to the Teams module so when we run a report, only records viewable by the user will be returned.

Thanks!

[ftreml]

i think you have to join the "teams" and "teams_users" tables to your queries, restricting resultset to viewable records. The report parameter "SUGAR_USER_ID" always contains the id of the currently logged on user

[enrikm]

Hi, I can't find the teams_users tables however I tried this query.

SELECT accounts.name
FROM accounts
JOIN accounts_cstm
ON accounts.id = accounts_cstm.id_c
JOIN teams
ON accounts_cstm.assigned_team_id_c = teams.id
JOIN users
ON accounts.assigned_user_id = users.id
JOIN users_cstm
ON users.id = users_cstm.id_c
WHERE accounts.deleted = 0
AND users.user_name = 'sugar_user_id'

It seems 'sugar_user_id' is not recognized that's why I tried to substitute a real user name however instead of getting all accounts viewable by that user, I am getting all the accounts assigned to that user. Any thing I am doing wrong?

Thanks