I have pentaho bi server ce v7.1.

recently I wrote a query in "sql over jdbc" datasource.
my query is like:

select count(id),
from logs group by status

the strange thing is that when I'm using this query everything works fine because status data type is integer. but when I replace status by browser (which is of type character varying) pentaho shows nothing!

any idea?