按两个实体搜索不适用于 JpaRepository

Question

我正在制作一个应用程序，其中包含一个带有钱包的用户配置文件，其中包含许多交易。

下面是事务类：

@Entity
@Table(name = "transactions")
public class Transaction extends BaseEntity {
@Column(name = "amount", nullable = false)
private BigDecimal amount;
@Column(name = "executed_on", nullable = false)
private LocalDateTime executedOn;
@Column(name = "is_top_up")
private boolean isTopUp;
@Column(name = "note")
private String note;
@ManyToOne(targetEntity = UserProfile.class)
private UserProfile sender;
@ManyToOne(targetEntity = UserProfile.class)
private UserProfile receiver;
public Transaction() {
}

这是钱包类

@Entity
@Table(name = "wallets")
public class Wallet extends BaseEntity {
@ManyToMany(targetEntity = Transaction.class, cascade = {
CascadeType.PERSIST,
CascadeType.MERGE
}, fetch = FetchType.EAGER)
@JoinTable(name = "wallets_transactions",
joinColumns = @JoinColumn(name = "wallet_id", referencedColumnName = "id"),
inverseJoinColumns = @JoinColumn(name = "transaction_id", referencedColumnName = "id")
)
private Set<Transaction> transactions;
public Wallet() {
this.transactions = new HashSet<>();
}
public Set<Transaction> getTransactions() {
return transactions;
}
public void setTransactions(Set<Transaction> transactions) {
this.transactions = transactions;
}
public void addTransaction(Transaction transaction) {
this.transactions.add(transaction);
}
}

我想要的是，通过发送方和接收方搜索条件获取所有交易。例如，用户"A"向用户"B"汇款。我正在使用 JpaRepository。最终结果应该在Page<Transaction>类中。

到目前为止，当仅使用findAllBySender(UserProfile sender, Pageable pageable)时，它确实有效，并且我得到了完全正确的交易。但是当我尝试Page<Transaction> findAllBySenderAndReceiver(UserProfile sender, UserProfile receiver, Pageable pageable);当我的数据库具有至少 1 条记录的测试数据时，我得到一个包含 0 个元素的Page<T>。

Answer 1

已解决。事实证明，我有一个逻辑错误。谢谢大家的帮助。