Unable to view the data in database views

[Sharan Ellendul]

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

[RaghavSh]

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

[Sharan Ellendul]

[RaghavSh]

@Sharan Ellendul Does marking left join make any difference?

[Sharan Ellendul]

No, there is no difference.