Datagrid Multisort

[inavanick]

Hello,

I am using structures_datagrid along with both Array and SQL datasources. I am in need to use multi-sorting of columns, but doesn't seem to work with the Array datasource. I have read that not all data sources support multi-sort, but I just don't see how this can apply with Array as PHP supports array_multisort. And I have seen it used in the source code as well. I'm assuming I'm doing something wrong, and thought I would look to someone more experienced with this package than I.

The datagrid methods I am using are sortRecordSet() and setDefaultSort(). Also, I did make sure to use both of them prior to bind(). I would be most appreciative if someone could show me how to use multi-sort with Array datasource.

Secondly, I did try SQL entered directly in the bind() method along with connection options. The multisort does work, however, once the SQL query I pass in contains a subquery, the grid bombs. I tried hiding the subquery behind a view, with no success. If Array is not an option at this time for multi-sort, I would be grateful for help with this issue.

Thanks in advance for any help what-so-ever!
_________________
Issac

[mark]

(Answered via PEAR's bug tracker.)