Sortable Column for those non-DataColumn?

[qiansen1386]

In Yii1 if the column is not specified in DataProvider, there will not be any filter and we could not sort the table based on this column as well.
example. we have a column called Subtotal in Quotation_Item gridview.
it may looks like this

array(
            'header'=>'Subtotal',
            'value'=>'$data->getSubtotal()',
            'footer'=>'Total: '.$model->total,
        ), 

But how about we add some variable like compare and filter
E.g.

array(
            'header'=>'Subtotal',
            'filter'=>'number',
            'compare' => 'number'
            'value'=>'$data->getSubtotal()',
            'footer'=>'Total: '.$model->total,
        ), 

I post it here, so that i think that may be a sweet improvement in Yii2. Feel free to correct me, if i said anything wrong. Or we can implement a similar outcome by make some modification in Model instead of View?

I am apologized for my poor English.

[cebe]

to allow sorting and filtering your value has to be calculated in the database. if your model calculates it in afterFind() or similar way you are not able to filter or sort by that field anymore.
You can add values to the select query like this:

$query->select[] = 'SUM(price) AS subtotal';

You also need to declare a property in your AR class to hold the value after find.

Marked this issue as documentation to add description about the topics to the guide.

[qiansen1386]

So you mean we do that inside Model via a SQL statement. Okay. That will work fine.

But is there any way to allow us make a logic columns on the fly, as long as we can define their relation with the primary key? Sorry, I don't have a clearly use case. I just imagine when we need to combine some data from external resources, And that part may not be done by either making a View or other SQL solution.

Or we can use afterFind() to do so as well? Anyway, It is just a suggestion. Whether is it make sense or not?

[cebe]

for reference:

• http://www.yiiframework.com/wiki/653/displaying-sorting-and-filtering-model-relations-on-a-gridview/
• http://www.yiiframework.com/doc-2.0/guide-output-data-widgets.html#sorting-data

[dynasource]

docs are quite clear about this.