Can I use 'Group by' in SQL Query editor of IBM Jazz Reporting Service ?
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?
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?