How to add parameters to IN clause in spring data repository native query

Question

folks,

I have a problem finding a way to send parameters for IN clause in a native query through Spring data repository. I tried sending list of strings, concatenated and formatted strings... nothing helped

I think you are supposed to separate question from answer using the checkbox at the bottom for that : stackoverflow.com/help/self-answer — TheBakker
– TheBakker, Commented Apr 27, 2018 at 12:54

Pang · Accepted Answer · 2024-08-28 07:25:50Z

4

Here is the solution:

@Repository
public interface Repo extends PagingAndSortingRepository<Log, Long>
{
    @Query(value = QUERY, nativeQuery = true)
    List<OrderExecutionLog> findTop1OrderByInitiatedAsc(String[] types);

    String QUERY = "SELECT log.* " +
            "FROM log" +
            "WHERE `type` IN (?3) ";
}

I tried several variations with a list or concatenated strings and so on ... but a simple array gave me the desired result. I think that the Spring community need to take a look at this simple issue i encountered.

Good luck. Hope this helps someone like me :)

edited Aug 28, 2024 at 7:25

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered May 1, 2018 at 7:33

a.valchev

3884 silver badges10 bronze badges

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

Comments

Pang · Accepted Answer · 2024-08-28 07:26:14Z

2

If you have a list of strings which are to be passed as parameter for an IN clause:

@Query(value="SELECT * FROM SOME_TABLE WHERE COLUMN_SOME_NAME IN :someList", nativeQuery = true)
List<T> getList(List<String> someList);

edited Aug 28, 2024 at 7:26

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Aug 5, 2020 at 20:25

Abhinav Manthri

3575 silver badges21 bronze badges

1 Comment

Greg Over a year ago

Can you please edit your answer to contain an explanation?

Collectives™ on Stack Overflow

How to add parameters to IN clause in spring data repository native query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related