Package org.openiam.esb.repository

Interface ReportCriteriaParamRepository

All Superinterfaces:

AbstractEntityRepository<ReportCriteriaParamEntity,String>, AbstractKeyEntityRepository<ReportCriteriaParamEntity,String>, AbstractKeyNameEntityRepository<ReportCriteriaParamEntity,String>, org.springframework.data.repository.CrudRepository<ReportCriteriaParamEntity,String>, org.springframework.data.jpa.repository.JpaRepository<ReportCriteriaParamEntity,String>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<ReportCriteriaParamEntity>, org.springframework.data.repository.PagingAndSortingRepository<ReportCriteriaParamEntity,String>, org.springframework.data.repository.query.QueryByExampleExecutor<ReportCriteriaParamEntity>, org.springframework.data.repository.Repository<ReportCriteriaParamEntity,String>

@Repository
public interface ReportCriteriaParamRepository
extends AbstractKeyNameEntityRepository<ReportCriteriaParamEntity,String>

This is repository for working with ReportCriteriaParam

Author:

Andrey Lezhebokov

Method Summary

Modifier and Type	Method	Description
List<ReportCriteriaParamEntity>	findByReportInfoId(String reportId)	Find list ReportCriteriaParamEntity by Report id
List<ReportCriteriaParamEntity>	findByReportInfoName(String reportName)	Find list ReportCriteriaParamEntity by Report name
ReportCriteriaParamEntity	getReportParameterByName(String reportId, String paramName)	Find one ReportCriteriaParamEntity by Report id and name

Methods inherited from interface org.openiam.esb.repository.AbstractEntityRepository

getPageable

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, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

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

count, exists, 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 Detail

findByReportInfoId

@Query("SELECT r FROM ReportCriteriaParamEntity r WHERE r.report.id=:reportId ORDER BY name ASC")
List<ReportCriteriaParamEntity> findByReportInfoId(@Param("reportId")
                                                   String reportId)

Find list ReportCriteriaParamEntity by Report id

Parameters:

reportId -

Returns:

findByReportInfoName

@Query("SELECT r FROM ReportCriteriaParamEntity r WHERE r.report.name=:reportName ORDER BY name ASC")
List<ReportCriteriaParamEntity> findByReportInfoName(@Param("reportName")
                                                     String reportName)

Find list ReportCriteriaParamEntity by Report name

Parameters:

reportName -

Returns:

getReportParameterByName

@Query("SELECT r FROM ReportCriteriaParamEntity r WHERE r.report.id=:reportId AND r.name=:paramName ORDER BY name ASC")
ReportCriteriaParamEntity getReportParameterByName(@Param("reportId")
                                                   String reportId,
                                                   @Param("paramName")
                                                   String paramName)

Find one ReportCriteriaParamEntity by Report id and name

Parameters:

reportName -

reportId -

Returns: