How to set Multiple ACLs on the Table and Fields of same Table

[snow_hard252]

HI

I require to set Multiple ACLs on a table and fields of same table.

1) A role based ACL on the Table

2) A condition based ACL on the Fields of same Table: which is javascript based ( no role is mandatory)

Please hint.

Thanks

Hardy

[sumukh]

Hardy,

Thanks for sharing the screenshots. The first 2 ACL's, you'll have to consolidate into ONE as they're conflicting. The system will check both the conditions i.e. If user is the OWNER AND has ecmdb_admin role. Make this as ONE ACL and check these conditions in the script section:

if(current.owned_by == gs.getUserID() || gs.hasRole('ecmdb_admin'){

                    true;

}else{

                    false;

}

Hope this helps.

Thanks.

[snow_hard252]

HI Sumukh,

Appreciate your time.

Sorry, I might have messed up the 2nd ACL. But my intention is to have:

1) CI record to have complete access to ecmdb_admin

2) Only Location Field to have write access on CI record when current user is same as owned_by

So waiting for your reply for this case.

Thanks

Hardy

[sumukh]

Ok. So you don't need the second ACL. 1st and 3rd should do the job. Please mark second one as inactive and see if it works.

[snow_hard252]

HI Sumukh,

I think I got it.

Thanks for your time.

Hardy