Constraint Problem in Access Group

JPQL Syntax Query Not Working - Below I Mentioned the error

 JpqlSyntaxException: Errors found for input jpql:
[select extract(HOURfromwl.startTime)startTime, count(wl.id)

CommonErrorNode [<unexpected: [@3,15:24='HOURfromwl',<61>,1:15], resync=extract(>]
CommonErrorNode [<mismatched token: [@4,25:25='.',<68>,1:25], resync=.startTime)startTime, count(wl.id) from worklog$WorkLog wl join sec$User user3, worklog$SubProjectMember sm3, worklog$SubProject s3, worklog$Project p3, worklog$Client c3>]

Could you provide the whole JPQL string that you are executing?

select 
extract(HOUR from WL.startTime) ,count(WL.id)
from worklog$workLog WL
inner join sec$User SU on WL.domain_id = SU.login
left join  worklog$SubProjectMember SBM on SU.id= SBM.member
left join worklog$SubProject SP on SP.id = SBM.sub_project
left join worklog$Project P on P.id = SP.project
left join worklog$Client C on C.ID=P.client
left join worklog$Department D on D.ID=C.department
where D.dept_manager.id = 'acd605b9-3efe-d1ff-513d-669eb10b59fb' 
group by extract(HOUR from WL.startTime)

The code you provided looks like SQL and is very different from the code in the first error message. Can you explain this?

I convert this SQL query into JPQL Query , but extract function is not accepted in JPQL.

Could you provide the JPQL with EXTRACT that doesn’t work for you?

JPQL Query:

    select extract(HOUR from WL.startTime),count (WL.id) from worklog$WorkLog WL join sec$User user3, worklog$SubProjectMember sm3, worklog$SubProject s3, worklog$Project p3, worklog$Client c3 where 
WL.domainID = user3.login and user3.id = sm3.member.id and s3.id = sm3.subProject.id and p3.id = s3.project.id and c3.id = p3.client.id and c3.client_manager.id = :session$userId

Hi.
Could you please share with us a small sample project along with reproduction scenario that demonstrates the issue.