I'm using JPA NamedQuery to create a DTO. And in my Query I have as condition an IN and as parameter IN has values with white spaces in the middle. (Ex: 9292-929). and these values with whitespace, returns nothing. Only values with no space.
@Query("SELECT NEW br.com.dto.LancamantoDto(m.id, r.id) \n" +
"FROM Lancamento l \n" +
"WHERE l.seuNumero IN (:seuNumero) \n" +
"AND l.data = :data")
List<LancamentoDto> findAllBySeuNumeroAndData(@Param("seuNumero")List<String> seuNumero, @Param("data")LocalDate data);