我有以下mongo文件
{
"_id" : ObjectId("5fc4b2061c2dab6097d460eb"),
"customerReferenceId" : "170901040",
"firstName" : "first_1032",
"lastName" : "last_1032",
"email" : "1032@test.com",
"phone" : "0501032103",
"registrationIp" : "80.80.80.1032",
"commonData" : {
"localId" : "000001032",
"bankAccounts" : [
{
"id" : "5fc4b2061c2dab6097d460f0",
"webUiId" : NumberLong(396),
"bankCode" : 12,
"branchCode" : 1,
"bankAccountNumber" : "19053",
"bankDetails" : "bank",
"freeText" : "Free text",
"productTypeSource" : "LENDER",
"bankAccountsCoOwners" : []
}
]
}
}
mongo存储库是
@Repository
public interface CustomerRepository extends ExtendedRepository<CustomerEntity, String> {
Optional<CustomerEntity> findByCommonDataLocalId(String localId);
Optional<CustomerEntity> findByEmail(String email);
@Query("{ 'commonData.bankAccounts.bankCode' : ?0, 'commonData.bankAccounts.branchCode' : ?1 , 'commonData.bankAccounts.bankAccountNumber' : ?2 }")
Optional<CustomerEntity> findByBankAccount(String bankCode, String branchCode, String bankAccountNumber);
我正试图通过客户的银行代码、银行分行和银行帐号来查询客户。存储库中的前两个查询工作正常。对于第三个,我不认为有一种方法没有
@Query
但是现在第三个查询出错了,我无法得到客户
暂无答案!
目前还没有任何答案,快来回答吧!