here's the answer: there's no way you can do select man_id, man_type from tablename group by man_id
and expecting it to return something meaningful. man_type needs to be either included in your groupby (in which case, it equals a "distinct" type of query) or used as an aggregate (first, last, count, etc etc etc) On Saturday, August 3, 2013 8:52:21 PM UTC+2, Matt Grham wrote: > > Fields to be shown: > > fields = ( db[str_tableName].Man_ID, > db[str_tableName].Man_Type) > > On Saturday, August 3, 2013 11:32:18 AM UTC-7, Niphlod wrote: >> >> what are the "fields" you're requiring ? Do you know that any groupby >> type of query can only include the group by column(s) and all the other >> fields need to be an aggregate of the "basic" field (such as count, min, >> max, etc) ? >> >> On Saturday, August 3, 2013 8:09:39 PM UTC+2, Matt Grham wrote: >>> >>> 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
