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.