I am using spring framework and working repository level implementations.
I have a class:
@Repository
public interface MyClassReadRepository extends ReadRepository<MyClass, Integer>
In this class there is a method that looks like this:
@Query("SELECT a FROM MyClass a WHERE a.type IN :myType ORDER BY :someProperty :someOrder")
Page<MyClass> findByTypeAndOrder(@Param("myType") List<MyType> myType, @Param("someProperty")String someProperty, @Param("someOrder")String someOrder, Pageable pageable)
But apparently the Query structure is wrong: ":someProperty" should be an identifier...
My question is: how to pass order and sort parameters in the example above?
Thanks in advance!