Package com.bytedesk.ticket.ticket

Interface TicketRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<TicketEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<TicketEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<TicketEntity>, org.springframework.data.repository.ListCrudRepository<TicketEntity,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<TicketEntity,Long>, org.springframework.data.repository.PagingAndSortingRepository<TicketEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<TicketEntity>, org.springframework.data.repository.Repository<TicketEntity,Long>

public interface TicketRepository
extends org.springframework.data.jpa.repository.JpaRepository<TicketEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<TicketEntity>

Method Summary

Modifier and Type	Method	Description
long	countByStatus(String status)
long	countByStatusNot(String status)
List<TicketEntity>	findByAssigneeContainingAndCreatedAtBetween(String assigneeUid, LocalDateTime startTime, LocalDateTime endTime)
List<TicketEntity>	findByDepartmentUidAndCreatedAtBetween(String departmentUid, LocalDateTime startTime, LocalDateTime endTime)
List<TicketEntity>	findByOrgUidAndCreatedAtBetween(String orgUid, LocalDateTime startTime, LocalDateTime endTime)
Optional<TicketEntity>	findByProcessInstanceId(String processInstanceId)
Optional<TicketEntity>	findByUid(String uid)

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, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

count, delete, exists, findAll, findAll, findAll, findBy, findOne

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

findAll, findAllById, saveAll

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

findAll

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

findByUid

Optional<TicketEntity> findByUid(String uid)

findByProcessInstanceId

Optional<TicketEntity> findByProcessInstanceId(String processInstanceId)

findByDepartmentUidAndCreatedAtBetween

List<TicketEntity> findByDepartmentUidAndCreatedAtBetween(String departmentUid,
 LocalDateTime startTime,
 LocalDateTime endTime)

findByAssigneeContainingAndCreatedAtBetween

List<TicketEntity> findByAssigneeContainingAndCreatedAtBetween(String assigneeUid,
 LocalDateTime startTime,
 LocalDateTime endTime)

findByOrgUidAndCreatedAtBetween

List<TicketEntity> findByOrgUidAndCreatedAtBetween(String orgUid,
 LocalDateTime startTime,
 LocalDateTime endTime)

countByStatus

long countByStatus(String status)

countByStatusNot

long countByStatusNot(String status)