How can I use findBy method with multiple or(|) and(&) operators?

Asked Jul 03 '18 at 10:57

Active Jul 04 '18 at 07:03

Viewed 117 times

For the below sql script I can write the below method(findByCreateDateBetweenorRRNOrCurrency).

Page<CustomObject> findByCreateDateBetweenAndPoutRrnOrPoutPassport(Pageable pageable, Date startDate, Date endDate, String RRN, String Currency);

where

createDate between CONVERT(Datetime, '2018-06-29 16:17:15.763', 120) and CONVERT(Datetime, '2018-06-30 16:17:15.763', 120) 
or RRN='N0000002628607' or currency = 'AZN'

How can I write findBy method for the below sql script?

where 
createDate between CONVERT(Datetime, '2018-06-29 16:17:15.763', 120) and CONVERT(Datetime, '2018-06-30 16:17:15.763', 120) 
and (RRN='N0000002628607' or currency = 'AZN')

edited Jul 04 '18 at 07:03

asked Jul 03 '18 at 10:57

MehmanBashirov

1

Clearly JPQL has no CONVERT method ... – Jul 03 '18 at 15:43
1

I you have the SQL available, use the Native query on your @Query method. – The Coder Jul 03 '18 at 18:16

How can I use findBy method with multiple or(|) and(&) operators?

0 Answers0