ranjisona
(Ranjisona)
June 6, 2018, 1:22pm
#1
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>]
krivopustov
(Konstantin Krivopustov)
June 13, 2018, 6:55pm
#3
Could you provide the whole JPQL string that you are executing?
ranjisona
(Ranjisona)
June 14, 2018, 11:28am
#4
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)
krivopustov
(Konstantin Krivopustov)
June 16, 2018, 5:58pm
#6
The code you provided looks like SQL and is very different from the code in the first error message. Can you explain this?
ranjisona
(Ranjisona)
June 19, 2018, 11:06am
#7
I convert this SQL query into JPQL Query , but extract function is not accepted in JPQL.
krivopustov
(Konstantin Krivopustov)
June 19, 2018, 4:18pm
#8
Could you provide the JPQL with EXTRACT that doesn’t work for you?
ranjisona
(Ranjisona)
June 20, 2018, 8:05am
#9
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
firstova
(Natalia Firstova)
June 22, 2018, 2:56pm
#11
Hi.
Could you please share with us a small sample project along with reproduction scenario that demonstrates the issue.