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.
