hus.censoCamas.repo

Interface SubgrupoRepo

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Subgrupo,java.lang.Integer>, org.springframework.data.jpa.repository.JpaRepository<Subgrupo,java.lang.Integer>, org.springframework.data.repository.PagingAndSortingRepository<Subgrupo,java.lang.Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Subgrupo>, org.springframework.data.repository.Repository<Subgrupo,java.lang.Integer>

public interface SubgrupoRepo
extends org.springframework.data.jpa.repository.JpaRepository<Subgrupo,java.lang.Integer>

Method Summary

Modifier and Type	Method and Description
java.util.List<Subgrupo>	findAll()
java.util.List<java.lang.String>	findByGrupo(java.lang.String grupo)
Subgrupo	findByNombre(java.lang.String nombre)

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

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

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

findAll

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

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

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

count, exists, findAll, findOne

Method Detail

findAll

java.util.List<Subgrupo> findAll()

Specified by:

findAll in interface org.springframework.data.repository.CrudRepository<Subgrupo,java.lang.Integer>

Specified by:

findAll in interface org.springframework.data.jpa.repository.JpaRepository<Subgrupo,java.lang.Integer>

findByNombre

Subgrupo findByNombre(java.lang.String nombre)

findByGrupo

@Query(value="select distinct s.hsunombre as nombreSubgrupo\nfrom HPNDEFCAM as c\njoin HPNSUBGRU as s\non c.HPNSUBGRU = s.oid\nJOIN HPNGRUPOS as g\non c.HPNGRUPOS = g.oid\nwhere g.HGRNOMBRE like ?1 ",
       nativeQuery=true)
java.util.List<java.lang.String> findByGrupo(java.lang.String grupo)