Database view issue showing results

[Abigail]

Hello,

I have a database view that includes four tables:

• asmt_assessment_instance
• incident
• sys_user
• asmt_metric_result

Within the database view, I created the following fields:

• User Comment → Element: amr3_string_value
• Manager Comment → Element: amr4_string_value

The issue is that some users can see the stored values, while for others, the columns appear blank. The columns themselves are always visible, but the data is missing for certain users.

Any idea what might be causing this?

[Ankur Bawiskar]

@Abigail 

did you check if the user have read access to those fields?

if not then they will see blank data for it on list.

Please use access analyzer and debug

Access Analyzer 

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

[Abigail]

Hello @Ankur Bawiskar 
This is my result 

The user have access to the information, so i don't know why is not working

[Ankur Bawiskar]

@Abigail 

which columns are those? those are fields from your view table right?

did you check any field level READ ACL is blocking?

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