Package ca.uhn.fhir.jpa.dao.data

Interface ITermValueSetConceptViewOracleDao

All Superinterfaces:

org.springframework.data.repository.CrudRepository<TermValueSetConceptViewOracle,IdAndPartitionId>, IHapiFhirJpaRepository, org.springframework.data.jpa.repository.JpaRepository<TermValueSetConceptViewOracle,IdAndPartitionId>, org.springframework.data.repository.ListCrudRepository<TermValueSetConceptViewOracle,IdAndPartitionId>, org.springframework.data.repository.ListPagingAndSortingRepository<TermValueSetConceptViewOracle,IdAndPartitionId>, org.springframework.data.repository.PagingAndSortingRepository<TermValueSetConceptViewOracle,IdAndPartitionId>, org.springframework.data.repository.query.QueryByExampleExecutor<TermValueSetConceptViewOracle>, org.springframework.data.repository.Repository<TermValueSetConceptViewOracle,IdAndPartitionId>

public interface ITermValueSetConceptViewOracleDao
extends org.springframework.data.jpa.repository.JpaRepository<TermValueSetConceptViewOracle,IdAndPartitionId>, IHapiFhirJpaRepository

Method Summary

Modifier and Type	Method	Description
List<TermValueSetConceptViewOracle>	findByTermValueSetId(int theFrom, int theTo, Long theValueSetId)
List<TermValueSetConceptViewOracle>	findByTermValueSetId(Long theValueSetId, String theDisplay)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findByTermValueSetId

@Query("SELECT v FROM TermValueSetConceptViewOracle v WHERE v.myConceptValueSetPid = :pid AND v.myConceptOrder >= :from AND v.myConceptOrder < :to ORDER BY v.myConceptOrder")
List<TermValueSetConceptViewOracle> findByTermValueSetId(@Param("from")
 int theFrom,
 @Param("to")
 int theTo,
 @Param("pid")
 Long theValueSetId)

findByTermValueSetId

@Query("SELECT v FROM TermValueSetConceptViewOracle v WHERE v.myConceptValueSetPid = :pid AND LOWER(v.myConceptDisplay) LIKE :display ORDER BY v.myConceptOrder")
List<TermValueSetConceptViewOracle> findByTermValueSetId(@Param("pid")
 Long theValueSetId,
 @Param("display")
 String theDisplay)