ORA-00979 error when sorting by date

1

im getting the error

12-05 11:26:10 WARN metabase.query-processor :: Query failure: ORA-00979: not a GROUP BY expression

when im trying to change the date sorting method in a question that is grouped by.

any hints?

info: MB 0.27 / oracle 11.2 / openjdk version “1.8.0_151”

2

while monitoring the the sql trace file ,ive got the following sql code that oracle is refusing to execute:

/* Formatted on 5/12/2017 4:07:03 μμ (QP5 v5.256.13226.35538) */
– Metabase:: userID: 1 queryType: MBQL queryHash: dec23d56bfafdfef331a03d843c02f05715776abdf194faa9b3743ef3a7d18e1

SELECT COUNT (*) AS “count”,
( ( EXTRACT (
MONTH FROM TRUNC (
“SWIFTNAVIGATORAPI”.“ORDERSIMPORTEDV4”.“DATEENTERED”,
‘q’))
+ 2)
/ 3)
AS “DATEENTERED”
FROM “SWIFTNAVIGATORAPI”.“ORDERSIMPORTEDV4”
GROUP BY ( ( EXTRACT (
MONTH FROM TRUNC (
“SWIFTNAVIGATORAPI”.“ORDERSIMPORTEDV4”.“DATEENTERED”,
‘q’))
+ 2)
/ 3)
ORDER BY CAST (“ORDERSIMPORTEDV4”.“DATEENTERED” AS DATE) DESC

ORA-00979: not a GROUP BY expression