JPQL in ValueCollection Datasource









I am using above valueCollectionDataSource Query,If I exeute I get result as

start_time count
21/08/2018 0
22/08/2018 1
22/08/2018 1

But I want result as
start_time count
21/08/2018 0
22/08/2018 2

I am unable to see the query you are running, so I’ll just propose an answer and you can see if it will work…

> select p.startDate, count(p)  from sample$Dates p
> group by p.startDate

Results:
image

Below query which is used
select
function(‘to_char’,w1.startTime,‘dd/mm/yyyy’),(sum(w1.duration_in_milli_second)/3600000) exe_count
from worklog$WorkLog w1
where @between(w1.startTime,now-5,now,day,user_timezone)
group by w1.startTime
order by w1.startTime