Mario tr

Greenhorn
+ Follow
since Apr 15, 2020
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Mario tr

how to translate sql query to spring boot query?

select  ru.id, ru.name,
case when a.r_id is null
then false
else true
end as acc
from ru
left join  a
on ru.id  = a.r_id  and a.a_id = 1
left join b
on b.id  = a.a_id



it doesn't work in this, where is problem:
@Query("select  ru.id, ru.name,
case when a.r_id is null
then false
else true
end as acc
from ru
left join  a
on ru.id  = a.r_id  and a.a_id = 1
left join b
on b.id  = a.a_id")
List<ExamplesDto> getExamples();


1 year ago