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
/*
* ServiceLineRepository.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.ServiceLine;
/**
* @author AbleVets
*/
@Repository
public interface ServiceLineRepository extends CrudRepository<ServiceLine, Integer>
{
@Query("SELECT sl FROM ServiceLine sl")
Set<ServiceLine> findAllServiceLines();
@Query("SELECT sl FROM ServiceLine sl WHERE LOWER(sl.description) like LOWER(CONCAT('%',:desc,'%'))")
Set<ServiceLine> fetchByDescription(@Param("desc") String description);
ServiceLine findByDescription(String description);
}