Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 1,033 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