ORAN Alignment - PCI updates for SON usecase

Issue-ID: INT-2173
Signed-off-by: Malarvizhi Paramasivam <malarvizhi.44@wipro.com>
Change-Id: I26815aa3ea71b8ac3381922864dd455e2282d6b1

1 files changed, 6 insertions, 0 deletions

diff --git a/ransim/ransimctrlr/RANSIM-CTRLR/src/main/java/org/onap/ransim/rest/api/repository/NRCellCURepository.java b/ransim/ransimctrlr/RANSIM-CTRLR/src/main/java/org/onap/ransim/rest/api/repository/NRCellCURepository.java
index cbad231..f0addab 100644
--- a/ransim/ransimctrlr/RANSIM-CTRLR/src/main/java/org/onap/ransim/rest/api/repository/NRCellCURepository.java
+++ b/ransim/ransimctrlr/RANSIM-CTRLR/src/main/java/org/onap/ransim/rest/api/repository/NRCellCURepository.java
@@ -20,11 +20,17 @@
 
 package org.onap.ransim.rest.api.repository;
 
+import java.util.List;
+
 import org.onap.ransim.rest.api.models.NRCellCU;
+import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.CrudRepository;
 import org.springframework.stereotype.Repository;
 
 @Repository
 public interface NRCellCURepository extends CrudRepository<NRCellCU, Integer> {
+    
+    @Query("SELECT cd from NRCellCU cd where cd.pciCollisionDetected=true or cd.pciConfusionDetected=true")
+    List<NRCellCU> getCellsWithCollisionOrConfusion();
 
 }