General query and group

Hi,

I want to create a general query that changes depending on the group the user is in.

  • For example if the user is in group 1 then my query changes:
    SELECT * FROM user WHERE group=1
  • And if the user is in group 2 then
    SELECT * FROM user WHERE group=2

im using the free version.

Thanks

you can't do that unless you use data sandboxing, which is a paid feature

Ok thanks you,
Have a nice day