in database view values for some fields showing empty

[rakshith_shetty]

I've created database view connecting interaction_related_record and interaction table . It works fine for me but when other user entering this view he can filter out records with empty number but records that are left are showing no value which is not a case when I'm logged as admin. I've checked ACLs and there is one read acl that I disabled to see if that is the issue but it didn't help. I run debug of security rules and it showed nothing. can someone assist. If i Open table users can view all fields data , if they open in database view some fields values not showing 

[jcmings]

I think it has to be an ACL. Did you check the user's access to the target tables? It may be field-level.

[rakshith_shetty]

Hi @jcmings 

There are no restrictions at the table level. I have created an ACL and granted field-level read access . Users can access the data if they directly open the table; however, they are unable to view the data in the database view.

[jcmings]

Which fields specifically are blank on the database view?

[rakshith_shetty]

Task field is blank, attached screenshot.