We're updating the issue view to help you get more done. 

The SQL query "SELECT COUNT (...) GROUP BY" doesn't work on nested properties in the Web Management Console

Description

Below query works fine in gs-ui but fails in web-ui
select count(p1.x),p2.y from z where
rownum<5000 and p1.x='ZZ' group by p2.y

Attached reproduction test and snapshots from the gs-ui and web-ui

Workaround

None

Acceptance Test

manual

Status

Assignee

Evgeny Fisher

Reporter

Yuval Dori

Labels

Priority

Critical

SalesForce Case ID

00011583

Fix versions

Commitment Version/s

None

Due date

None

Product

XAP

Edition

Premium

Platform

All