Unable to view the data in database views

[ellendulash]

Hi All,

We have created a database view on below tables and user have access all these table (both read and report_view access).

sn_grc_issue

sn_smart_asmt_scope_item

sn_smart_asmt_m2m_instance_scope_item

sn_smart_asmt_instance

sn_smart_asmt_question_instance

User is able to open these tables individually and view the records. But the when user is viewing the database view most of the columns are empty. Could anyone tell the way to find the root cause and fix this?

Thank you

[Raghav Sharma24]

share the database view configuration? what is the where clause?

[ellendulash]

[Raghav Sharma24]

@ellendulash Does marking left join make any difference?

[ellendulash]

No, there is no difference.