Package no.nsd.qddt.domain.questionitem

Interface QuestionItemRepository

  • All Superinterfaces:
    BaseRepository<QuestionItem,​java.util.UUID>, org.springframework.data.repository.CrudRepository<QuestionItem,​java.util.UUID>, org.springframework.data.jpa.repository.JpaRepository<QuestionItem,​java.util.UUID>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<QuestionItem>, org.springframework.data.repository.PagingAndSortingRepository<QuestionItem,​java.util.UUID>, org.springframework.data.repository.query.QueryByExampleExecutor<QuestionItem>, org.springframework.data.repository.Repository<QuestionItem,​java.util.UUID>
    @Repository
public interface QuestionItemRepository
extends BaseRepository<QuestionItem,​java.util.UUID>

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      org.springframework.data.domain.Page<QuestionItem> findAll​(org.springframework.data.domain.Pageable pageable)  
      org.springframework.data.domain.Page<QuestionItem> findByQuery​(java.lang.String name, java.lang.String question, java.lang.String responseDomain, org.springframework.data.domain.Pageable pageable)  

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

        count, delete, delete, delete, deleteAll, exists, findOne, save

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

        deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAll, flush, getOne, save, saveAndFlush

      • Methods inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

        count, findAll, findAll, findAll, findOne

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

        count, exists, findAll, findOne

    • Method Detail

      • findAll

        org.springframework.data.domain.Page<QuestionItem> findAll​(org.springframework.data.domain.Pageable pageable)
        Specified by:
        findAll in interface org.springframework.data.repository.PagingAndSortingRepository<QuestionItem,​java.util.UUID>

      • findByQuery

        @Query(value="SELECT qi.* FROM QUESTION_ITEM qi LEFT JOIN audit.responsedomain_aud r on qi.responsedomain_id = r.id and qi.responsedomain_revision = r.rev WHERE ( qi.name ILIKE :name or qi.question ILIKE :question or r.name ILIKE  :responseDomain ) ORDER BY ?#{#pageable}",
       countQuery="SELECT count(qi.*) FROM QUESTION_ITEM qi LEFT JOIN audit.responsedomain_aud r on qi.responsedomain_id = r.id and qi.responsedomain_revision = r.rev WHERE ( qi.name ILIKE :name or qi.question ILIKE :question or r.name ILIKE  :responseDomain ) ",
       nativeQuery=true)
org.springframework.data.domain.Page<QuestionItem> findByQuery​(@Param("name")
                                                               java.lang.String name,
                                                               @Param("question")
                                                               java.lang.String question,
                                                               @Param("responseDomain")
                                                               java.lang.String responseDomain,
                                                               org.springframework.data.domain.Pageable pageable)