Interface ITermValueSetConceptViewOracleDao

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      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, findAll, findAll, findAllById, flush, getById, getOne, saveAll, saveAllAndFlush, saveAndFlush
      • Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

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

        count, exists, findAll, findOne
    • Method Detail

      • findByTermValueSetId

        @Query("SELECT v FROM TermValueSetConceptViewOracle v WHERE v.myConceptValueSetPid = :pid AND v.myConceptOrder >= :from AND v.myConceptOrder < :to ORDER BY v.myConceptOrder")
        List<TermValueSetConceptViewOraclefindByTermValueSetId​(@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<TermValueSetConceptViewOraclefindByTermValueSetId​(@Param("pid")
                                                                 Long theValueSetId,
                                                                 @Param("display")
                                                                 String theDisplay)