Table value not visable in List View or Reports

[John H1]

I have a custom table with several fields that we have been using for over a year now. I just noticed that I'm not able to show one of the values in a list view or in a report.  I went into the List Collector and was able to find that value but the other fields vales from the same table were there. I now the need to have that value in a list view, any assistance would be appreciated.

[Gunjan Kiratkar]

Hi @John H,

I think this issue appears because of ACL. Do you add the read ACL to that table? 

Regards,

Gunjan

[shloke04]

Hi John,

This definitely is an Read operation ACL issue. What you need to do to solve this:

1) Navigate to the table where that field is present.

2) Open the List view of that table as for example I have done it for Incident Table.

3) Now Right click on the Header and select "Configure-->Security Rules" as shown below

4) Look for only Read Operation ACL on this Table for that particular field.

5) Once found, open that ACL and check for condition or Role which might be restricting this.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[John H1]

That's what I thought, maybe I'm missing something but this is what I have.

[shloke04]

Sure. Couple of things to look at here:

1) Can you share screenshot of Read and Write ACL by opening the records and then sharing them again.

2) Also can you go to the Dictionary of that field and make sure the Field is really on that table or not.

There can be a possibility that the field is on a different table and has been added to the Form Layout using a Reference Field. If that is the case then you need to do the same dot walk in in the report as well.

Can you share screenshot of your Field Dictionary and confirm if that is on the same table or not.

Other than these two reason I doubt there can be anything else stopping this from becoming visible.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke