How to restrict records to users based on roles and state

[kalyani23]

Hi,

I need to restrict draft state records to users, when the logged in user is not the requestor.

how to achieve this using acls. please let me know

Thanks in advance,

Kalyani

[kalyani23]

Hi,

the condition as state is draft not working , the addquery code is working . can u help to fix this .

Thanks in advance

[Sohail Khilji]

you can use query business rule for this.

[SunilKumar_P]

Hi @kalyani23, we can also restrict record from visibility via before-query business rule. Below is the example of restrciting the Incidents visibility where the Incidents are closed and caller is not logged in user.

Condition:

current.caller_id!=gs.getUserID()

Script:

(function executeRule(current, previous /*null when async*/ ) {

    var grpQuery = 'state!=7^ORstate=NULL';

    current.addEncodedQuery(grpQuery);

})(current, previous);

Regards,

Sunil

[Dr Atul G- LNG]

Hi @kalyani23 

I am not coder but I have question

I need to restrict draft state records to users, when the logged in user is not the requestor.

Atul: So you need one a user logged in and if his/her name not in Requestor that in state field Draft state not visible?