Question

OQL throwing error

0

Theoretically this should be simple… I just want a sum of one attribute within a group. The error also shows up if I try to Select * from… Can someone straighten me out or is this a bug in the platform?

asked 2022-07-07

Bill Fleming

4 answers

Tim v Steenbergen · Answer 1 · 2022-07-07

No, there are no bugs in this platform ;-)

Try this

from CM.ReportForOQL r
group by r.Category
select r.Category, SUM(r.Extension)
order by r.Category

Bill Fleming · Answer 2 · 2022-07-07

copied as given it chokes on the order by (...expecting SELECT)

If I remove the order by line then the error is Cannot resolve the path part ‘cm’.

Bill Fleming · Answer 3 · 2022-07-07

duh, cm should be CM. It still chokes on the order by but when I remove it and use CM I still have the original issue:

Bill Fleming · Answer 4 · 2022-07-07

Double DUH… keyword alias:

SELECT r.Category as Category, SUM(r.Extension) as Extension