How do you link Control Objectives to Citations in report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2023 05:26 AM
Hi @Gary45 ,
To Relate a control objective to a citation :
- Navigate to All > Policy and Compliance > Compliance > Citations.
- Open a citation.
- In the Control Objectives related list, click New.
However, this relationship is stored in "sn_compliance_m2m_statement_citation" Table.
