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.
