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]

@Sharan Ellendul I created a database view b/w 2 tables to debug this:

sn_grc_profile and sn_smart_asmt_scope_item and it showed me data successfully. I did not use the sn_grc_issue table because it does not have a corresponding record in "sn_smart_asmt_scope_item" table which satisfy "scitem_record=issue_sys_id" condition.

Your where clause seems correct , I replicated that but did not find data with "sn_grc_issue" table.

Try the one which I suggested and check the difference.

Please mark the answer correct/helpful accordingly.