Thanks!
Can I ask how you can format individual fields in the grid, say, with bold
or color attributes?
Thanks again.
On Sunday, 19 January 2014 10:54:27 UTC-5, Anthony wrote:
>
> On Sunday, January 19, 2014 9:32:39 AM UTC-5, horridohobbyist wrote:
>>
>> I'm new to web2py and I'm playing around with SQLFORM.grid. I notice that
>> the display of string fields truncates at 20 characters, whereas SQLTABLE
>> did not impose such a limit. How do I loosen up this limit?
>>
>
> .grid(..., maxtextlength=1000)
>
> or per field:
>
> .grid(..., maxtextlength=1000, maxtextlengths={'mytable.myfield': 10})
>
> FYI, by default, SQLTABLE truncates at 16 characters, though that can be
> overridden globally or per field, as with the grid.
>
> Also, while I can disable exportclasses, I can't get rid of the "Export:"
>> label beneath the grid. I would think that something like
>> "exportclasses=None" would eliminate everything to do with export.
>> Altogether, this is not very intuitive.
>>
>
> .grid(..., csv=False)
>
>
>> And finally, if I specify the fields to be fetched from the database
>> (using "fields="), I would think that the excluded fields (for example,
>> 'Id') wouldn't show up in the Search field dropdown. How would the user
>> ever know what 'Id', for example, to search for?
>>
>
> db.mytable.id.readable = False
>
> You can also use your own custom search query builder and widget via:
>
> .grid(..., searchable=my_query_builder, search_widget=my_widget)
>
> SQLFORM.grid could be a bit more flexible.
>>
>
> If you have ideas for further flexibility, feel free to submit a pull
> request.
>
> Anthony
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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.
