Also, note that you can define a view in your database that represents all the columns you would like in your grid, and then create a DAL model to represent that view (could get tricky if you also want to use the grid for create/update -- you would need to set up some triggers in the database).
Anthony On Saturday, February 25, 2017 at 8:43:04 AM UTC-5, Anthony wrote: > > On Saturday, February 25, 2017 at 1:10:10 AM UTC-5, Carlos Cesar Caballero > wrote: >> >> Hi Anthony, thanks for your answer. >> >> We are using (besides web2py) the php yii2 framework. Yii2 has this >> functionality specifying custom functions for sorting and filtering of >> fields in grids ( >> http://www.yiiframework.com/wiki/621/filter-sort-by-calculated-related-fields-in-gridview-yii-2-0/). >> >> Will be very difficult to implement something like this in web2py? >> > > It appears the linked Yii example is not fully generalizable -- it works > for a virtual field that merely concatenates other fields because you can > define searching and sorting queries for it that can be handled by the > database. I don't think it would work with arbitrary Python expressions, > many of which would not be able to be executed by the database in order to > handle searching and sorting on the generated values. > > In general, I'm not sure it makes sense for web2py virtual fields to be > searchable and sortable because in order to work for all possible virtual > field functions, the searching/sorting would have to be done in Python > after selecting* all* records from the table (which may not be practical > at all for large tables). > > Instead, it would probably make sense to implement a more limited > functionality that allows adding SQL expressions as additional columns, as > discussed here: https://github.com/web2py/web2py/issues/1553. > > >> I am asking because the web2py source code sometimes overwhelmed me, the >> grid is just a function with around 917 code lines and is a little >> difficult to understand for me. >> > > Agreed, the grid code has become somewhat unwieldy. It should probably be > refactored into more modular code. > > 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.
