Re: {Disarmed} Re: {Disarmed} [web2py] Re: Searching and sorting virtual field on grid

2017-02-27 Thread Carlos Cesar Caballero Díaz
El 25/02/17 a las 08:43, Anthony escribió: 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 w

Re: {Disarmed} [web2py] Re: Searching and sorting virtual field on grid

2017-02-25 Thread Anthony
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).

Re: {Disarmed} [web2py] Re: Searching and sorting virtual field on grid

2017-02-25 Thread Anthony
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://

{Disarmed} [web2py] Re: Searching and sorting virtual field on grid

2017-02-24 Thread Carlos Cesar Caballero Díaz
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/).