Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Query(value="select date(start_time) as ride_date, count(distinct(ride_id)) as rides from ride where is_ended = 1 and ride_amount > 0 and start_time >= date_sub(curdate(), interval 6 day) group by ride_date",nativeQuery=true)
- public List<Object[]> getForVBChart();
- List<Object[]> object = rideRepository.getRidesPerDayForVBChart();
- for (Object[] a : object) {
- System.out.println("Details "
- + a[0]
- + " "
- + a[1]);
- }
- Details 2018-06-16 8
- Details 2018-06-17 3
Add Comment
Please, Sign In to add comment