Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

/*
* ClinicalServcieRepository.java
* Copyright (c) 2017 Veterans Affairs.
*/
package gov.va.oneconsult.seoc.api.repository;

import java.util.Set;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;
import gov.va.oneconsult.seoc.api.model.ClinicalService;

/**
* @author AbleVets
*/
@Repository
public interface ClinicalServiceRepository extends CrudRepository<ClinicalService, Integer>
{

@Query("SELECT cs FROM ClinicalService cs WHERE (cs.discontinued is null or cs.discontinued=false)")
Set<ClinicalService> findAllClinicalServices();

ClinicalService findByDescription(String description);

@Query("SELECT cs FROM ClinicalService cs where cs.description in :descs")
Set<ClinicalService> findMultipleClinicalServices(@Param("descs") Set<String> descs);

@Query("SELECT cs FROM ClinicalService cs where (cs.discontinued is null or cs.discontinued=false) and cs.description in :descs")
Set<ClinicalService> findMultipleActiveClinicalServices(@Param("descs") Set<String> descs);
}