OutboxRepository.java

package com.checkout.paymentgw.payment.outbox;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;
import java.util.UUID;

public interface OutboxRepository extends JpaRepository<OutboxMessage, UUID> {

    @Query("select m from OutboxMessage m where m.publishedAt is null order by m.createdAt asc")
    List<OutboxMessage> findUnpublished(Pageable page);
}