Hide list view columns in Reports

Aakhiil
Tera Expert

Hi Experts,

I have one requirement to hide one column in list view  Name: "end user email"  So I write one ACL(Image added below)
And its working as expected in list view and we are unable to see that column in list view everything is good for now. And when I try to create a report and in configure section "choose columns" when i try to select the columns there also i am not able to see. this was also good my ACL is working as expected. 
But the issue is  when i select any reference type field (+) when i click to expand the reference fields and click on Order fields i was able to see the restricted "end user email" column in reports. Here also they don't want to see 
How can I achieve this.

Note: In list view the  table call (csm_transaction) when i try to open one record its redirecting to another table(u_lum_order)

Aakhiil_0-1694067800307.png

 

Aakhiil_1-1694068061770.png


Any help will be appreciated.

Thanks in Advance
Aakhil

 



1 ACCEPTED SOLUTION

OlaN
Giga Sage
Giga Sage

Hi,

Not entirely sure, but I believe you have to restrict read access to that specific field (to those roles that should be able to read the data) for this to work.

 

View solution in original post

6 REPLIES 6

To my knowledge, there is no way you can hide a field only on reports.

You can set up ACLs that runs on table level, to restrict who can report on records, but that will not apply on field level.

The only way I know about, is to restrict reading the data, which will prevent users from accessing the field in both reports and lists/forms alike.

Thanks @OlaN 

 

I have tried it Now everything is good.

 

Thanks for your help.