Hi,
I'm trying to achieve a very similar thing, but with "smartgrid" and not
having any luck with response to 'viewargs' on Details page. It always
displays the entire list of fields without virtuals no matter how I limit
the fields. Is there anything I am missing?
On Friday, June 6, 2014 at 8:21:41 AM UTC-4, Anthony wrote:
>
> Virtual field shows up OK in the "table" view, but :
>>
>
>> 1. It does not appear at all when I click on "View" button
>>
>
> By default, virtual fields don't show up in readonly forms, but you can
> list them in the "fields" argument. To pass the "fields" argument to the
> view form when using the grid, you can use the "viewargs" argument. Maybe
> something like:
>
> grid = SQLFORM.grid(db.mytable,
> viewargs={'fields': [f for f in db.mytable.__dict__
> if isinstance(db.mytable[f], (
> Field, Field.Virtual))]},
> ...)
>
> We should probably add an argument to SQLFORM to automatically include
> virtual fields in readonly forms. Feel free to submit a Google Code issue
> about that (reference this thread).
>
>
>> 2. are not used for "default" search
>>
>
> This would be difficult, as it would require selecting *all* the records
> from the database, calculating the virtual fields for all records, and then
> searching the Rows object using Python. Currently the search functionality
> works by issuing a query to the database (i.e., the database does the
> searching and returns only the matching records), and because the virtual
> fields are not stored in the database, it is not possible for search to be
> based on them. If this is important, you might consider using a computed
> field instead.
>
> 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/d/optout.
