Linking sn_grc_issue and sn_grc_task tables

[prashant_a_]

How to link sn_grc_issue and sn_grc_task tables to get a consolidated issue register view

[GouthamAnumolu]

You can link remediation task to issue by using "Issue" reference field on remediation task.  If you are asking about joining them, you can create DB view combining both tables.

[Tanushree Maiti]

Hi @prashant_a_ 

sn_grc_task table's Issue is Referenced to  sn_grc_issue table.

So sn_grc_task table's Issue is sn_grc_issue table's number (Display is true)