Group rows by this data column
Default:
This Lens will order your data by a the specified column, and show a divider in the grid marking the beginning of all records in that group. You can also subTotal groups using the sumLens property.
For example you have a MEMBERS table which is a list of people who are members of a club. In the table there is a field called STATE indicating what US State the user resides in.
Setting $lens->groupLens='STATE'; will produce the following if the grouping field is visible:
| Alaska | Abraham | Nielson
| | Joseph Ahmed | Boesky
| | Bill | Baggins
| | Arkansas | Mee | Siam
| | Maido | Bola
| | Billy | Clinton
|
and if the grouping field is hidden:
Alaska
| | Abraham | Nielson
| | Joseph Ahmed | Boesky
| | Bill | Baggins
| Arkansas
| | Mee | Siam
| | Maido | Bola
| | Billy | Clinton
|
To disable the error message which appears if the groupLens column is missing, set the language file class variable $txtErrGroupLens to an empty string ("").
Group Display
New in phpLens 5, you can use groupLens to define the sort order of the group, and select a different field to display as the group name. See groupDisplay.
Syntax
$lens->groupLens = 'ColumnName'; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.0]
|