Data Base view

[Ramesh_01]

I want to create a data base view of  Risk,control and compliance so that it should show the field in the below  image

[Shubham_Jain]

@Ramesh_01 

Step 1: Identify the tables

Step 2: Create the database view: Navigate to System Defination >> Database Views

Step 3: Define the view tables, Join conditions. Risk as Primary table, Control and Combined Joined Tables 

Step 4: Create view on Database view (Optional but recommeneded)

Step 5: Create reports on View

[Mohammad Danis1]

Hi @Ramesh_01 ,
Typically, these tables could have a common field that allows us to join them together.
You can configure something like:

Table                                                                              Where Clause
grc_risk
grc_control                                                grc_risk_control.risk = grc_risk.sys_id
grc_control_compliance                           grc_control_compliance.control = grc_control.sys_id
grc_compliance                                        grc_control_compliance.compliance = grc_compliance.sys_id

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Mohammad Danish

[Ankur Bawiskar]

@Ramesh_01 

so what did you start with and where are you stuck?

what common field you are using?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ramesh_01]

I need to create a data base view of  Risk, Control and Remedition task table to display the fields in the image

there are no common fields