Filter the records

Hi Readers,

I have created a record as below, and there are 9 users using the application, and there are 3 groups 

For suppose
users are: u1, u2, u3, u4, u5, u6, u7, u8, u9
Groups: All users, Administrators, App1Users, App2Users 

All users group is a parent group.

Users in App1Users group are: u1, u2, u3, u4,
Users in App2Users group are: u5, u6, u7
Users in Administrators group are: u8 and u9 

Use case:
When users u8 or u9 login They should  be able to see all the records entered by all members who are using the application.
When users u5 or u6 or u7 login and see the records they should be able to see only the records which are entered by their group members
When users u1 or u2 or u3 or u4 login and see the records they should be able to see only the records which are entered by their group members

What i tried: 
I have used loggedinuser() function it helped me see the records entered only by the logged in user only; i failed to write an exception in the filter as i am not sure weather we can do that or not

Would like to know if we can do that use case if yes how, and would like to know if any exception can be created for filters created if yes how ??

and also would like to know what operation need to be used to check weather a name is present in list of names -- Includes and In did not work:(

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data