We have a query in our repository that has 2 in clause. One gets a list of ides, another gets about max of 10 values. In DB2 we get error code of 101 when we pass more than 8000 ids to first in clause. Another way is to edit query to use with clause with multi row value to join with table we use. But I can’t pass the list of values to repositories method.
My query is like this: