How do you link Control Objectives to Citations in report?

Gary45
Tera Contributor

‎03-22-2023 06:49 PM

I am trying to create Issue report with master data to be shown from Authority Documents table but when I try to pull the data beyond Control Objective table, I get blank values. I realise that there is an M2M table in between for Control Objective and Citations. Is there a way to resolve this using report configurations?

 

Thanks in advance

0 Helpfuls
  • 742 Views
2 REPLIES 2

Aman Sharma2
Tera Contributor

‎03-22-2023 11:39 PM

Hi @Gary45!

You may check this m2m table [sn_compliance_m2m_statement_citation] as a reference for your reports.

Please mark this as correct if applicable.

Preview file
89 KB
0 Helpfuls

Community Alums
Not applicable

‎03-23-2023 05:26 AM

Hi @Gary45 ,

To Relate a control objective to a citation :

  1. Navigate to All > Policy and Compliance > Compliance > Citations.
  2. Open a citation.
  3. In the Control Objectives related list, click New.

However, this relationship is stored in "sn_compliance_m2m_statement_citation" Table.

 

0 Helpfuls