It's all about the answers!

Ask a question

Can I use 'Group by' in SQL Query editor of IBM Jazz Reporting Service ?


ayesha siddiqui (111) | asked Oct 19 '15, 2:45 a.m.
edited Jan 01 '16, 5:59 p.m. by Geoffrey Clemm (30.1k33035)
Hi Jazz Team,

I am trying to create a graph showing work items per week over the last 1 month using IBM Jazz Reporting Service.I am using RTC 5.0.2 server.
I realized that grouping data in results is possible only by the drop down in the preview section on top , thus we can group only by columns available in that drop down.
But if I want to do group by Work item creation month  by editing query in query editor under Advanced tab I get the error

CRRGW5628E An com.foundationdb.sql.parser.SQLParserException error occurred when validating the input SQL string, caused by Encountered " "group" "GROUP "" at line 13, column 1. Was expecting one of: "fetch" ... "for" ... "with" ... "offset" ... "limit" ... "," ... ";" ... .

Is there any limitation that one can`t use group by clause in query editor here?



Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.