Remove grid condition based on user privileges

Scriptcase 9 General
#1

I have clients organized in workgroups. A user can only see the clients within their own workgroup (easily controlled in the grid sql stating “where workgroup = [grp_id]”). But if you are an administrator, you should be able to see all workgroups and all clients. That happens if you remove the where clause, but can’t come out with a good way to do it unless I actually have 2 grids and the correct one called based on admin privileges. Is there any way to make the sql more conditional? Case? If?

#2

Hi,

  1. In where statement add [glo_where]
  2. add a condition on Scriptinit if group=1 (admin) then [glo_where]=" workgroup >0" else [glo_where]=" workgroup =[grp_id]"
#3

Oh perfect. I’ll get on it! Thanks so much.

#4

Is that different than using sc_select_where(add)?

#5

Different way same result.

1 Like
#6

Another way to handle this is using a subselect clause in the WHERE clause.
where workgroup IN (select GroupID FROM AuthorizedGroupsTable where AuthorizedGroupTableUser - LoggedInUser)

Your admin would be authorized to all groups
Full Example…

SELECT
employee_id, first_name, last_name
FROM
employees
WHERE
department_id IN (SELECT
department_id
FROM
departments
WHERE
location_id = 1700)
ORDER BY first_name , last_name;

#7

I’ll see which works most efficiently. Thanks.