Grid Enhancements

Sorting

You can give user ability to sort grid data. This is done by calling makeSortable() function after field definition.

$g=$p->add('Grid'); $g->addColumn('name')->makeSortable(); $g->addColumn('surname')->makeSortable(); $g->setSource('user'); $g->dq->where('name is not null')->limit(5);

Sorting by calculated fields

$g=$p->add('Grid'); $g->setSource('user'); $g->dq ->where('name is not null') ->field('length(name) namelength') ->limit(5); $g->addColumn('name'); $g->addColumn('namelength') ->makeSortable('length(name)');