Package sk.iway.iwcm.doc.attributes.jpa

Interface DocAtrDefRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<DocAtrDefEntity,Long>, DomainIdRepository<DocAtrDefEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<DocAtrDefEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DocAtrDefEntity>, org.springframework.data.repository.PagingAndSortingRepository<DocAtrDefEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<DocAtrDefEntity>, org.springframework.data.repository.Repository<DocAtrDefEntity,Long>
@Repository public interface DocAtrDefRepository extends DomainIdRepository<DocAtrDefEntity,Long>

  • Method Summary

    Modifier and Type
    Method
    Description
    List<DocAtrDefEntity>
    findAllByDocId(Integer docId, Integer domainId)
     
    List<String>
    findDistinctGroups(Integer domainId)
     

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

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

    Methods inherited from interface sk.iway.iwcm.system.datatable.spring.DomainIdRepository

    findAllByDomainId, findAllByDomainId, findFirstByIdAndDomainId

    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.jpa.repository.JpaSpecificationExecutor

    count, findAll, findAll, findAll, findOne

    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

    • findDistinctGroups

      @Query(value="SELECT distinct(atr_group) FROM doc_atr_def WHERE domain_id=?1 ORDER BY atr_group", nativeQuery=true) List<String> findDistinctGroups(Integer domainId)

    • findAllByDocId

      @Query("SELECT d FROM DocAtrDefEntity d LEFT JOIN FETCH d.docAtrEntities a ON a.docId = :docId WHERE d.domainId = :domainId ORDER BY d.orderPriority") List<DocAtrDefEntity> findAllByDocId(@Param("docId") Integer docId, @Param("domainId") Integer domainId)