[web2py] groupby in sqlform.grid resulted into unsupported query

[Matt Grham]

I have a table like:

3 records found
Man_ID    Man_Type  
8                BC    
8                BC    
8                BC   

When I try to group by Man_ID, it does the grouping but it prints 
Unsupported Query on top of the table 

*Unsupported query
Man_ID    Man_Type  
8                BC  *

I used the following statement:

    grid = SQLFORM.grid(query=query, fields=fields, headers=myheaders, 
                create=False, deletable=False, editable=False, 
details=False, csv=False, 
                maxtextlength=64, 
                paginate=25,
                ui='jquery-ui',
                user_signature=False,
                searchable=searchable,
                sortable=sortable,
                groupby=db.mytable.Man_ID
                )

Can you help me here?

Thanks,

Matt

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.