Hi All,
I am facing a problem in data security using section acccess. I am unable to filter the data based on multiple fields.
As a user I need to see full projects of one company and some projects of other company where I am the user.
My Data is :
| COMPANYID | PROJID | PM |
| A | 1001 | USER1 |
| A | 1002 | USER1 |
| A | 1003 | USER2 |
| B | 1004 | USER2 |
| B | 1005 | USER2 |
| B | 1006 | USER3 |
| C | 1007 | USER3 |
| C | 2008 | USER3 |
| C | 1009 | USER4 |
My Access Matrix table is :
| Access | UserID | CompanyID | ProjID |
| ADMIN | USER | * | * |
| USER | USER1 | A | 1001 |
| USER | USER1 | A | 1002 |
| USER | USER2 | A | * |
| USER | USER2 | B | 1004 |
| USER | USER2 | B | 1005 |
| USER | USER3 | B | * |
| USER | USER3 | C | 1007 |
| USER | USER3 | C | 1008 |
| USER | USER4 | C | 1009 |
and my output for USER2 shoulsd be :
| Company ID | Proj ID | PM |
| A | 1001 | USER1 |
| A | 1002 | USER1 |
| A | 1003 | USER2 |
| B | 1004 | USER2 |
| B | 1005 | USER2 |
Thanks in advance.
Attached excel file for your reference.
Regards,
Veman Reddy
