Column visibility in List view and ACLs

[mitzaka]

Hi there, a question which I would love some help with.

I want to show the Short Description column form my change requests into the List view for My Approvals. To do so, I have added the column by personalizing the list view. However, this was only partially successful - I can see the Short Description content with Admin users, but not with other users. With 'regular' users I see this:

I am pretty sure it's a common of ACLs but I can't seem to figure it out. I checked this: Re: Column shown blank in list view in spite of having values

but I still can't get it done.

[harikrish_v]

Is this a field that you have added to the list layout via dot walking or did you create this field in the sysapproval table? If it is a field that you created in the sysapproval table, then create a read ACL for this field and add the user role to the Requires Role related list; if it is a field in some other table that you have added to this form/list layout using dot walking, then go to that table and check for any ACLs on this field.

Thanks & Regards,

Hari

[mitzaka]

This is a field I added via dot-walking, this is the short_description field from the change_request table, which extends the task table.

I checked the security policies on change_request table and there is no ACL specifically on that field. The weird thing is that I have another field in the Approvals list view, which again is added by dot-walking (Group Assignment Group), which I is visible with no problem....

[harikrish_v]

Can you create a read ACL for short_description for this role in the change_request table and see if the value is coming up?

[seanpmcclean]

Try this query to look at the Access controls:

nameINchange_request,change_request.*,change_request.short_description,task,task.*,task.short_description,*,*.*,*.short_description^operation=read

To get this you can right-click the actual short description field in the Change record itself and select "show security rules"

To trim this further I filtered by the operation "read"

There is a rule in the base instance that limits fields only to people who requested or opened the change.

Short Description

"You can read a change request if you opened it, or if you are the requested by of the record"

I'm wondering if this rule may be affecting your results - to test you might try impersonating someone, opening a couple of changes, and then looking at your list...

[mitzaka]

Yes, I am suspecting approving, meaning when I impersonate someone and create a change, I will have nothing in My Approvals,because an approval is not generated for myself. So I cannot properly test this....?!

I am thinking of disactivating the policy "You can read a change request if you opened it, or if you are the requested by of the record" and giving it a try.