Database view Report Data shows fileds type string is empty

[Le Son]

I created a database view
But when displaying records, fields of type string are empty and fields of type reference can be displayed.
How to display those fields

[Saurav11 · Accepted solution]

Hello,

In the list view which fields are string field? Did you check if the values for them are present on the actual table?

In the variable prefix use all lowercase letters it should mostly solve the problem.

Please mark my answer as correct based on Impact.