Interface ITermValueSetConceptViewDao

All Superinterfaces:
org.springframework.data.repository.CrudRepository<TermValueSetConceptView,Long>, IHapiFhirJpaRepository, org.springframework.data.jpa.repository.JpaRepository<TermValueSetConceptView,Long>, org.springframework.data.repository.ListCrudRepository<TermValueSetConceptView,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<TermValueSetConceptView,Long>, org.springframework.data.repository.PagingAndSortingRepository<TermValueSetConceptView,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<TermValueSetConceptView>, org.springframework.data.repository.Repository<TermValueSetConceptView,Long>

public interface ITermValueSetConceptViewDao extends org.springframework.data.jpa.repository.JpaRepository<TermValueSetConceptView,Long>, IHapiFhirJpaRepository
  • Method Summary

    Modifier and Type
    Method
    Description
    findByTermValueSetId(int theFrom, int theTo, Long theValueSetId)
     
    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 TermValueSetConceptView v WHERE v.myConceptValueSetPid = :pid AND v.myConceptOrder >= :from AND v.myConceptOrder < :to ORDER BY v.myConceptOrder") List<TermValueSetConceptView> findByTermValueSetId(@Param("from") int theFrom, @Param("to") int theTo, @Param("pid") Long theValueSetId)
    • findByTermValueSetId

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