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

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 gov.va.oneconsult.seoc.api.model.ServiceHptc;
import gov.va.oneconsult.seoc.api.model.ServiceHptcId;

public interface ServiceHptcRepository extends CrudRepository<ServiceHptc, ServiceHptcId>
{
@Query("SELECT s FROM ServiceHptc s WHERE s.medicarecode=:msc)")
Set<ServiceHptc> findByMedicareCode(@Param("msc") String msc);

@Query("SELECT s FROM ServiceHptc s order by s.medicarecode)")
Set<ServiceHptc> findAll();
}