JPA Params with nativeQuery in Postgresql

Question

I have a custom @Query in a repository:

    @Query(value = "select CURRENT_DATE - INTERVAL '?1 days'", nativeQuery = true)
public List<OrderEntity> getOrders(Integer numDays);

I want to add param in '?1 days' for example

getOrders(5) -> select CURRENT_DATE - INTERVAL '5 days'

But it doesn't work, not filter.

How can I write this query so that it works with JPA?

GMB · Accepted Answer · 2020-10-09 12:27:02Z

2

Does this work?

select CURRENT_DATE - ?1 * INTERVAL '1 day'

answered Oct 9, 2020 at 12:27

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1