About record-level display control by ACLs.

[Ohki_Yamamoto]

Suppose the following table is created and data is set.

In this case, we would like to use ACLs to control whether the data can be displayed or not at the record level.

For example, we would like to control that "columnC = "0" is hidden for users with a certain role".

I thought it would be possible to control it by using ACL's Condition etc., but I could not control it well.

We would appreciate it if you could tell us if there is a way to control it.

[Ankur Bawiskar]

Hi,

you can create field level READ ACL on Column C

Give correct role

This would hide it from list and form as well

Regards
Ankur

[Ankur Bawiskar]

@Ohki.Yamamoto 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[Ohki_Yamamoto]

Thank you very much.

I try again the setting ACL.

[Muhammad Khan · Accepted solution]

Hi Ohki,

You can achieve this requirement either using 1 Business Rule  or  2 ACLs.

1. Business Rule approach is as follows;

Note: Make sure to replace itil role in the Condition with your role, and use this 'columnC_Name', '!=', '0' in query.

2. ACLs approach is as follows;

First Read ACL gives the read access of all records of this table to all users with the itil_admin role;

Second Read ACL gives the read access (to all users with itil role) of only those records of this table where Age != 111.

Hopefully this will resolve your problem.