Use object properties as arguments in reactive crud repository @Query methods

Question

Try to solve the issue with usage filter object properties as arguments in @Query methods in reactive crud repository using spring-data-r2dbc.

@Query("SELECT id, someId FROM Foo WHERE someId=:query.someId"")
Flux<Foo> findByCollectionQuery(FooCollectionQuery query);

FooCollectionQuery:

@Value
public class PaymentCollectionQuery {

    @NotNull
    UUID someId;

}

Is there a possibility to provide the whole PaymentCollectionQuery object to @Query annotations specifying concrete property in query?

Right now I got the following exception:

java.lang.UnsupportedOperationException: Binding parameters is not supported for the statement 'SELECT id, someId FROM Foo WHERE someId=query.someId'

Answer 1

Try to use SpEL:

@Query("SELECT id, someId FROM Foo WHERE someId = :#{#query.someId}")
Flux<Foo> findByCollectionQuery(@Param("query") FooCollectionQuery query);