Помогите разобраться в двух проблемах
1.Не могу понять почему не подставляется значение из phoneNumber в '%?1%'
2.Если руками прописать в запрос ...LIKE '%33034%' ORDER BY... получаю org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [ua.project.dto.bpm.OrderDto2]
@Data
@AllArgsConstructor
@NoArgsConstructor
public class OrderDto2 {
private Long orderId;
private String state;
private Date created;
private Long isFinalState;
private Long bpmInstanceId;
private String channel;
private String phoneNumber;
private String fullName;
}
@Repository
public interface OrderRepository extends JpaRepository<Order, Long> {
@Query(value = "SELECT o.id AS orderid, s.description AS state, o.created, s.is_final AS isfinalstate, " +
"o.bpm_instance_id AS bpminstanceid, r.channel, o.phone_number AS phonenumber, " +
"q.first_name ||' '|| q.second_name ||' '|| q.last_name AS fullname FROM orders o JOIN states_ref s " +
"ON o.state_id = s.id JOIN (SELECT r.order_id, c.description channel, ROW_NUMBER() " +
"OVER (PARTITION BY r.order_id ORDER BY r.created DESC) AS rn FROM requests r " +
"JOIN channels_ref c ON c.id = r.channel_id) r ON r.order_id = o.id AND r.rn = 1 " +
"LEFT JOIN questionnaire q ON q.id = o.id WHERE o.phone_number LIKE '%?1%' ORDER BY o.created DESC", nativeQuery = true)
List<OrderDto2> findByPhoneNumberContaining(String phoneNumber);
}
запрос в DBeaver работает корректно
пробовал добавить List<OrderDto2> findByPhoneNumberContaining(@Param("phoneNumber") String phoneNumber и LIKE '%'+:phoneNumber+'%' ORDER BY --> InvalidDataAccessResourceUsageException: Named parameter not bound
Основные этапы разработки сайта для стоматологической клиники
Продвижение своими сайтами как стратегия роста и независимости