Create report with NOT IN conditions - Citation Mapping to Control Objectives

ShafrazMubarak
Giga Guru

We have our corporate policies mapped to UCF Citations and other citations imported for authority documents. We need to create a list view report on following scenarios. Is there a way apart from database view, we can achieve this.

 

1. Control Objectives of Policies which are not yet mapped to citation

2. Citations of selected Authority Document which are not yet mapped to a Control Objective. 

3. % of Control Objectives in a Policy which are mapped so far to external citations. 

4