How to define Before/Query Business Rule to give users read access to the table based on conditions?

[Aki18]

I have the requirements to allow users to access (read) a table based on the following conditions.

1) Users can read all the records which "Confidential" is FALSE.

2) For records with "Confidential" is TRUE, users can read them only if the logged in user's Company is same as "Company [u_company]" field value.

I created the Before Query Business Rule below, but the result is that users can read all the records which "Company" is same as logged in user's one, regardless of the "Confidential" check... Could someone please advise me on how to meet the requirements using BR?

(function executeRule(current, previous /*null when async*/) {
	
	current.addQuery('u_company', gs.getUser().getCompanyID());
	
})(current, previous);

Best Regards,

Aki

[Gunjan Kiratkar]

Hi @Aki18 

Can you try below code and see what you are getting in info message:-

(function executeRule(current, previous /*null when async*/) {
	
	current.addQuery('u_company', gs.getUser().getCompanyID());
       gs.addInfoMessage("Query:" + current.getEncodedQuery());
	
})(current, previous);

[Aki18]

Hi @Gunjan Kiratkar ,

Thank you for your reply. Here is the log message displayed when accessed the table list:

Query:u_company=5d7c1eca1b1611909f7c10ee034bcb8a^ORDERBYDESCu_number